Pareto Chart showing same percentage for same quantity categories

[power2]

Hello everyone,

The pareto I created shows the same percentage for the same quantity categories. As you can see in the screenshot, When the count is 3 on the x bar, the pareto shows %87 for all of them, and when it's 2 on the x bar, same thing, it shows %94 for all of them.

I want my pareto to randmoly pick the priority and just show me the cumulitaive percentage as it goes up.

How do I fix this?

Here is my measure:

Reason Pareto =

VAR Totaltags = CALCULATE(SUM(eTags[COUNT]), ALLSELECTED(eTags))

VAR Currentetags = SUM(eTags[COUNT])

VAR SummarizedTable =

SUMMARIZE(

    ALLSELECTED(eTags),

    eTags[Cause],

    "Count", SUM(eTags[COUNT])

)

VAR CumulativeSum =

SUMX(

    FILTER(SummarizedTable, [Count] >= Currentetags),

    [Count]

)

RETURN

CumulativeSum/Totaltags

[Anonymous]

Hi @power2 ,

When multiple categories have the same count, they end up with the same cumulative percentage. To resolve this, you need to ensure that the categories are uniquely identified, even when they have the same count. Could you please provide some raw data from the ‘eTags’ table (excluding any sensitive information) in Text format, along with your expected result and the backend logic based on your sample data? This will help us find an appropriate solution. You can refer to the following link for guidance on how to share the required information:

How to provide sample data in the Power BI Forum

Additionally, it would be helpful if you could share a simplified .pbix file. You can refer to the following link for instructions on how to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards