I created a calculated column for age of ticket as shown below.)
This is the DAX code used: Age of ticket(in days) = DATEDIFF( Fact_incident[Created DateTime], TODAY(), DAY
When I tried to creat a chart from the above data, the Age of ticket(in days) is placed in the values but it changes to a count which gives me a wrong figure. I want the exact numbers above to be on the chart and not changing it to “count of Age of ticket(in days)”
If you have this in a calculated column, then you should create a measure over this column using for example SUM or AVERAGE before placing it into a visual.
This will solve your problem quite quickly I would say.
Always look to use measures. It’s the best way to start of any analysis.
Check out the below video as well to get an idea of how you could potentially do this differently as well, using measures for everything
Initial problem is when you are dragging the field “Age of ticket(in days)” into Chart it is defaulting to Count. if you are looking to change it to some other aggregation. Then you can do through by right clicking on value field and changing aggregation as shown below.
Regarding your second point, do you need to show all values like for 13/05/2019 you need to show both 242 or 241 or sum of them i.e 483. If need to show both then pls share if there are any other column present. Better if you can share your sample PBIX file
Hi @Chukliz, we’ve noticed that no response has been received from you since January 10, 2020. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks!
