DAX - Cumulative % non-dates

[ivostammis]

Hi everyone,

I am currently trying to set up a colum with cumulative % of products. I have found several examples which cover cumulative calculation on dates (so increasing per month for example). However, my order of adding up the cumulative % will be based on the sort order for product totals, in decreasing order. I made an example in excel below which also shows the chart I eventually need to produce. 

Does anyone know whether it is possible at all to create this? I have been thinking about setting up a seperate table, using product totals, from there on I would need to add a dynamic calculated index from where on the cumulative total can be calculated I guess? 

[mwegener]

I have written a blog post to this topic today. Unfortunately in german, but maybe the screenshots give you an inspiration.

https://www.thinkbi.de/2019/10/20/dynamische-abc-analyse-mit-dax/

Looking for German Power BI content? Visit my blog.
http://www.thinkbi.de/

[ivostammis]

Thanks!

Good to learn a bit more about the quick measures. I needed exactly the solution as described by Mwegener regarding the pareto.

[mwegener · Accepted solution]

Hi,

this YouTube Video describe the way.

https://www.youtube.com/watch?v=bzF5kN2BQ60

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[amitchandak]

Have you tried Quick Measure?

Right-click on a table or field Fields section. Click on Quick Measure. Use running total from there

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.