I am sure everyone has used Pareto chart to understand the top x% contributing to y% of sales or so. However in excel it is easy to use and even in Power BI we can achieve it easily using DAX
FYI: I am using a sample data of mutual fund and data is not real
Problem arises when we have data that are repeating as shown below. Power BI instead of cumulating the data, it repeats the cumulative total in the next row (see below)
As shown in above example the cumulative is not appropriate and would give wrong result and ultimately the pareto would be like below there by giving wrong interpretation!
How to deal with this problem in Power BI
The problem can be solved by tweaking the DAX a little bit
Solution
We have to modify our Cumulative DAX using additional layer of ranking which can become a differentiator and thus breaks the tie
In my previous blog, I had shared the DAX query however I would like the reader to solve for it.
If require assistance, do let me know! Happy learning and upskilling
Comments