Help create simple ABC-analysis in PowerBI visual

Anonymous — Sun, 10 Jan 2021 11:42:04 GMT

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.

Re: Help create simple ABC-analysis in PowerBI visual

Anonymous — Sun, 10 Jan 2021 11:44:57 GMT

To clarify my original table (Seems formatting cut some detials), in the column "Category lvl 2", the values shoudl be ("category lvl 2" 1) for the first half and ("category lvl 2" 2) for the second half.

Re: Help create simple ABC-analysis in PowerBI visual

amitchandak — Mon, 11 Jan 2021 01:58:02 GMT

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

https://www.daxpatterns.com/abc-classification/

topic Re: Help create simple ABC-analysis in PowerBI visual in DAX Commands and Tips

Help create simple ABC-analysis in PowerBI visual

Re: Help create simple ABC-analysis in PowerBI visual

Re: Help create simple ABC-analysis in PowerBI visual