cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## Pareto chart: error in cumulative percentage

Hi,

I'm trying to create a Pareto chart, but I'm facing an issue with the calculation of the cumulative percentage.

My data looks like:

I want to built a pareto chart with the total stop time per reasonas a bar chart, and the cumulative percentage per reason as a line chart.

I first built a rank column: Rank = RANKX(ALL(FactsStopReasons[Reason]);[TotalStopTime])

This gives me:

As you can see, the rank has an equal value when the total stop time is equal.

This results in:

The bar chart is correct, but the cumulative view is not correct. The cumulative view doesn't work when the rank is equal.

My cumulative sum has following formula:

CumulativeStopTime = SUMX(TOPN([Rank];ALL(FactsStopReasons[Reason]);[TotalStopTime];DESC);[TotalStopTime])

Amount_All = CALCULATE([TotalStopTime]; ALL(FactsStopReasons[Reason]))

Pareto % = DIVIDE([CumulativeStopTime]; [Amount_All]; BLANK())

This is all working fine, also when I apply filters etc. But when values are equal, and as a consequence also the rank, my cumulative % is not correct.

I already tried to calculate a rank in power query, but this will limit me in the filters afterwards. It needs to be calculated on the fly in my opinion.

Who has any idea?

Many thanks for the feedback!

Regards,

Hans

2 REPLIES 2
Community Support

Hi @HansBa'

I made a test but can't reproduce the rank as yours, could you point out what's wrong with me?

Best Regards

Maggie

New Member

Hi Maggie,

In my table with the rank, the value for reason 90 are grouped. So the total StopTime for reason 90 = 11. The rank is based on the aggregated value.

Regards,

Hans

Announcements

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors