Forum Discussion
v-amarsh
6 years agoMicrosoft Employee
Cumulative sum
Hi Community, I am trying to get a running total on a field based on condition on a different column. Below is my input table along with expected output column (Cumulative Assigned)to produce . Col...
chadrenstrom
6 years agoAdvocate I
Not an answer, but similar idea to the Pareto chart in Excel. Unfortunately the Pareto chart doesn't exist in Power BI, but there have been a few blog posts around the internet on how to create them. The order changes based on the group total, so depending what you need, adding an index column prior to any calculations may not be the solution you need. Then again, this may be a step further than you're looking for.
v-amarsh
6 years agoMicrosoft Employee
Thanks for your reply chandrenstrom. I have tried using DAX version equivalent for Parento chart in Excel by some internet sources. However, the result is giving me scalar value of the total sum of values .
Thanks