Forum Discussion
Problems on implementing RunningSum measure using DAX
Hello, MFelix and v-yulgu-msft!
Thanks for yours explanations. On my scenario, I don´t have a specific column at my table to ranking be identified. The user chooses some options at the slicer. So, according with these selections, my ranking measure is calculated based on the revenue values.
Somehow, my ranking measure is a little "crazy". As you can see at the image, the position '2' dissapeared. The measure with red borders is my revenue (divided per 1000), and the Running Sum calculation is doing correctly until the RK '5', where the calculation gets wrong.
BTW, I had to transcript the results into a Excel grid, because I cannot paste the image here :(
| RK | Running Sum | Revenue |
| 1 | 316,79 | 316,8 |
| 3 | 457,83 | 141 |
| 4 | 497,9 | 40,1 |
| 5 | 212,77 | 31,7 |
| 6 | 559,56 | 30 |
| 7 | 251,79 | 9 |
| 8 | 258,58 | 6,8 |
Best regards,
Marcos Fattibello
Hi mfattibello,
On my scenario, I don´t have a specific column at my table to ranking be identified. The user chooses some options at the slicer. So, according with these selections, my ranking measure is calculated based on the revenue values.
Didn't my original suggestion meet your requirement? In my original post, the rank value and running total value will be changed dynamically based on slicer selection.
Would you please provide some sample data (detailed data in source table)? And provide the measures you used currently.
Regards,
Yuliana Gu