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,
Could you share the link from where i can download your workbook. Please remove information which is not relevnt for the question.