How to deal with cumulative total with tied values in Power BI

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

After removing the tie in data, Cumulative % becomes perfectly fine

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