Forum Discussion
Help create simple ABC-analysis in PowerBI visual
Hi,
I'm fairly new to PowerBI, and tried to scan all resources available and also with "trial and error" without success on the below question, so now hoping for your help to find a good solution.
I have a table with the following structure (More complex in reality):
| Productname | Category lvl 1 | Category lvl 2 | Sales |
| Product 1 | "Category lvl 1" 1 | "Category lvl 2" 1 | 5 |
| Product 2 | "Category lvl 1" 1 | "Category lvl 2" 1 | 5 |
| Product 3 | "Category lvl 1" 1 | "Category lvl 2" 1 | 10 |
| Product 4 | "Category lvl 1" 1 | "Category lvl 2" 1 | 10 |
| Product 5 | "Category lvl 1" 1 | "Category lvl 2" 1 | 35 |
| Product 6 | "Category lvl 1" 1 | "Category lvl 2" 1 | 35 |
| Product 7 | "Category lvl 1" 1 | "Category lvl 2" 2 | 5 |
| Product 8 | "Category lvl 1" 1 | "Category lvl 2" 2 | 5 |
| Product 9 | "Category lvl 1" 1 | "Category lvl 2" 2 | 10 |
| Product 10 | "Category lvl 1" 1 | "Category lvl 2" 2 | 10 |
| Product 11 | "Category lvl 1" 1 | "Category lvl 2" 2 | 35 |
| Product 12 | "Category lvl 1" 1 | "Category lvl 2" 2 | 35 |
And what I want to accomplish in my "visual" is a table/matrix looking like this: (Base on ABC-analysis, A= first 70%, B = 20%, C=10%)
| Category lvl 1 | Category lvl 2 | ABC-classification | Productname | Sales | Sales% |
| "Category lvl 1" 1 | 200 | 100% | |||
| "Category lvl 2" 1 | 100 | 50% | |||
| A | 70 | 70% | |||
| Product 5 | 35 | 35% | |||
| Product 6 | 35 | 35% | |||
| B | 20 | 20% | |||
| Product 3 | 10 | 10% | |||
| Product 4 | 10 | 10% | |||
| C | 10 | 10% | |||
| Product 1 | 5 | 5% | |||
| Product 2 | 5 | 5% | |||
| "Category lvl 2" 2 | 100 | 50% | |||
| A | 70 | 70% | |||
| Product 11 | 35 | 35% | |||
| Product 12 | 35 | 35% | |||
| B | 20 | 20% | |||
| Product 9 | 10 | 10% | |||
| Product 10 | 10 | 10% | |||
| C | 10 | 10% | |||
| Product 7 | 5 | 5% | |||
| Product 8 | 5 | 5% |
I believe that I have solved the measure "Sales%" so that it aggregates on different levels etc, so what I need most is a pragmatic solution for the "static" ABC-analysis. (Should never change based on filtering etc.).
Thanks in advance and hoping for your expertise in solving this.
BR
2 Replies
Anonymous , Have you check this blog from Greg, if that can help
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-ABC-Classification/td-p/479146
or
