Pareto diagram

[Syndicate_Admin]

Good morning, I am trying to make a pareto chart with several levels, but when I do I try to see more details about my global category the accumulated does not go well.

Pareto first level.

When I hit one of the categories, it comes out like this.

This is the measure I am using (I understand that as I am doing the summerize on the Causes column, when trying to use it with another I do not give myself what I need but I do not know how to do it)

Accumulated Cause =

Var CostReason = SUM(Repairs[Corrective Action Cost])

Var Total CostReason = CALCULATE(SUM(Repairs[Corrective Action Cost]),ALL(Repairs))

return

DIVIDE(

SUMX(FILTER(SUMMARIZE(ALLSELECTED(Repairs),Repairs[Cause],"CostReason",SUM(Repairs[Corrective Action Cost])),[CauseCost]>=SUM(Repairs[Corrective Action Cost])),[CauseCost]),Total CostReason,0)

[v-stephen-msft]

Hi @DanielBds04 ,

Maybe these examples will help you:

https://blog.enterprisedna.co/creating-a-pareto-chart-in-power-bi-advanced-dax/

https://www.mssqltips.com/sqlservertip/6152/how-to-create-a-pareto-chart-in-power-bi-desktop/

https://exceleratorbi.com.au/pareto-analysis-in-power-bi/

https://powerbi.tips/2016/10/pareto-charting/

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.