Forum Discussion
New KPI visual showing incorrect data.
I'm trying to use the new KPI visual and have it working great for one of my measures. I have tried to use it for another however and I am getting odd results that I can't figure out. Below is a ...
Hi, thanks for the reply. The aggregate is SUM.
Sorry, I've just re-read your comment and I think that explains it i.e. using the value of the last date on the axis. I guess I need to create a cumulative measure then?
Yes. Check out this post for more information: http://www.daxpatterns.com/cumulative-total/
1 2 3 4 5 6 7 8 | Cumulative Quantity := CALCULATE ( SUM ( Transactions[Quantity] ), FILTER ( ALL ( 'Date'[Date] ), 'Date'[Date] <= MAX ( 'Date'[Date] ) ) ) |