cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

Pareto diagram

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.

DanielBds04_0-1631980815011.png

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

DanielBds04_1-1631980880492.png

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)
1 REPLY 1
v-stephen-msft
Community Support
Community Support

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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!