Forum Discussion
HerrPowerBI
3 years agoNew Member
Cumulative sum
Hello I have a dataset where I'm trying to calculate the sum for each row (a cumulative sum). The dataset is ordered by a ranking that goes from 1-10. I have created a measure that works okay, bu...
Greg_Deckler
3 years agoCommunity Champion
HerrPowerBI Use your ID instead? If you need an absolute unique ranking, you can use this:
The Mythical DAX Index - Microsoft Power BI Community
Also, see if this helps:
- HerrPowerBI3 years agoNew Member
Thank you for your response.
Unfortunately, none of the solutions above worked for me. I know how I can sort it by ID, but the rating is not following the order of ID's. I also have to be able to pick out someones name by using the filter and still be able to cumulate the values of that specific filtered view.