Forum Discussion
PipSqueak
6 years agoFrequent Visitor
AB Classification / Pareto Principle quad analysis
I'm looking to create a quad analysis model which will filter by branch/region/company/date. It uses 2 dimensions (Products and Customers) and classed into 4 classifications AA, AB, BA, BB which uses...
v-juanli-msft
6 years agoCommunity Support
Hi PipSqueak
You could refer to these links:
https://exceleratorbi.com.au/pareto-analysis-in-power-bi/
https://www.youtube.com/watch?v=m49G3PgspLE
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
PipSqueak
6 years agoFrequent Visitor
Hi Maggie,
I've read those, but really I want to be able to rank the products/customers into their quads AA, AB, BA, BB. And I want to be able to filter them by branch/region/dates too. So that means each time a filter is chosen, the cumulative are calculated and the quads are re-arranged. Is this something I can do with DAX?