Forum Discussion

power2's avatar
power2
Frequent Visitor
2 years ago

Pareto Chart showing same percentage for same quantity categories

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
 
 
 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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