Forum Discussion
Solved
Running Total on non ordered values
Hi, I need a help with following scenario: I need to present cumulative value by category and category must be ordered asc by value. When calculating it using Value Cumulative = calculate(sum(Sa...
hi,@raionpbi
After my research, you can use this formula as below:
Measure = CALCULATE(SUM(Sales[value]),FILTER(ALL(Sales),[rank]<=MAXX(Sales,[rank])))
Result:
here is pbix, please try it.
https://www.dropbox.com/s/y78z2mozfxof0hz/Running%20Total%20on%20non%20ordered%20values.pbix?dl=0
Best Regards,
Lin
hi,@raionpbi
After my research, you can use this formula as below:
Measure = CALCULATE(SUM(Sales[value]),FILTER(ALL(Sales),[rank]<=MAXX(Sales,[rank])))
Result:
here is pbix, please try it.
https://www.dropbox.com/s/y78z2mozfxof0hz/Running%20Total%20on%20non%20ordered%20values.pbix?dl=0
Best Regards,
Lin
Thanks a lot!