Forum Discussion

corange's avatar
corange
Icon for Post Patron rankPost Patron
4 years ago

Pareto Analysis & Measures

Hi everyone,    I am after some recommmendations / directions.    I have created a Pareto Analysis on POWER BI using the following measures:    Total_Amount = SUMX(JobDetails, JobDetails[Servi...
Need Help
YukiK's avatar
YukiK
Icon for Impactful Individual rankImpactful Individual
4 years ago

If the purpose is to get the rank over the whole table, then you may use RANKX(ALL(JobDetails), [Total_Amount]) instead of what you have?

corange's avatar
corange
Icon for Post Patron rankPost Patron
4 years ago

I would like to be able to use filter and categorise it by different field, like clients, service type and rates card.