Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello,
I have been working with Power BI for a short time and have a problem where I can't get any further. I want to accumulate lines and output the value per line. Not the gesatmkumulation that I get there. If I have a time structure it is no problem. Only now I have articles without time structure and want to use the values for later calculations e.g. ABC analysis. Does anyone have any advice for me ? The data looks like in the table, that's all I have and I want to calculate the column "Cumulativ Row Value".
| Produkt | Value | Rank | Cumulativ Row Value |
| f | 20 | 1 | 20 |
| g | 17 | 2 | 37 |
| b | 12 | 3 | 49 |
| c | 11 | 4 | 60 |
| a | 10 | 5 | 70 |
| e | 7 | 6 | 77 |
| d | 6 | 7 | 83 |
I have already tried a lot with SUM, SUMX, CUMULATE... in the form under Internet
Thank you very much!
Solved! Go to Solution.
On a normal field when you right-click in visualization. pane You get an option for running total. Also, you can create a quick measure. Right-click on a table or field under field pane and you will get that option
On a normal field when you right-click in visualization. pane You get an option for running total. Also, you can create a quick measure. Right-click on a table or field under field pane and you will get that option
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.