Pareto Chart

AndreaRSMRCT 

Without table names, I will have to do my best.

First you want to create a measure for Cost and Revenue.

Cost = Calculate(Sum('TableName'[Amount]), [Voice]="Cost")

Revenue = Calculate(Sum('TableName'[Amount]), [Voice]="Revenue")

Then create a cost and Revenue measure for All projects. From here forward, I will just do Cost and you can replicate for Revenue.

Cost All Projects = Calculate([Cost], ALL('TableName'[Project]))

Next, create a project Rank measure: (look out for the comma space comma in this one)

Project Cost Rank = RANKKX( ALL('TableName'[Project]), [Cost], , DESC)

Next, create a Project Cost Pareto Value:

Project Cost Pareto Value = SUMX( TOPN( [Project Cost Rank], ALL ('TableName'[Project]), [Project Cost Rank], ASC ), [Cost] )

Finally, create a Cost Pareto %:

Cost Pareto % = DIVIDE( [Project Cost Pareto Value], [Cost All Projects])

Use your combo graph and use the Cost Pareto % for the line, put your Projects on the X axis and the [Cost] on the Y Axis. You can also use these measure in a table with your Project on the row and the amount and pareto % in the values.

If this does not work, please provide additional details on table names, column names, and your model snapshot. This was a stab in the dark with limited information.

Hello Kcantor,

Thank you very much for your help.

I was able to create the Pareto chart following your instructions. :smileywink:

Best Regards,

Andrea