Forum Discussion

Frequent Visitor

6 years ago

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...

Community Support

6 years ago

I have no access to the picture.

You could upload pictures directly here or upload pictures/files to OneDrive and share the link here.

Best Regards
Maggie

Frequent Visitor

6 years ago

v-juanli-msft mwegener Sorry peeps, I didn't realise my link share is not working. Paste DataCustomer RankProduct RankCustomer/Product AB Classification

v-juanli-msft
Community Support
6 years ago
Hi PipSqueak

You could refer to these links:

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

https://community.powerbi.com/t5/Desktop/Pareto-80-20-calculation-for-items-making-up-80-of-Sales/td-p/30715

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
  Frequent Visitor
  6 years ago
  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?
  - mwegener
    Most Valuable Professional
    6 years ago
    Hi PipSqueak ,
    
    I think it is possible.
    
    could you post reusable sample data? An Excel file or PBIX file would be great.
    
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.