Forum Discussion
Helper IDAX - Cumulative % non-dates
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?
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.
4 Replies
- amitchandak
Super User
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. - mwegener
Most Valuable Professional
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.
- 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/
ivostammisThanks!
Good to learn a bit more about the quick measures. I needed exactly the solution as described by Mwegener regarding the pareto.
