I have calculated the count under the percentage range Using these two measures:-
- Pareto % Range =
SWITCH (
TRUE,
[Pareto % top n rev Time] <= 0.20, "A",
[Pareto % top n rev Time]>0.20 && [Pareto % top n rev Time]<=0.40,"B",
[Pareto % top n rev Time]>0.40 && [Pareto % top n rev Time]<=0.80,"C",
[Pareto % top n rev Time]>0.80 && [Pareto % top n rev Time]<=1,"D"
)
2.
Filter Class pareto SKU = Var TopSKURAnge = SELECTEDVALUE('Top SKU'[Top SKU Range])
Var CurrentSelection = SELECTEDVALUE(Class[Column1])
Var BudStatus = [Pareto % Range]
Return
SWITCH(
TRUE(),
TopSKURAnge = "0-20%" && CurrentSelection = "A" && BudStatus = "A",1,
TopSKURAnge = "20-40%" &&CurrentSelection = "B" && BudStatus = "B",1,
TopSKURAnge = "40-80%" &&CurrentSelection = "C" && BudStatus = "C",1,
TopSKURAnge = "80-100%" &&CurrentSelection = "D" && BudStatus = "D",1,
0)
I got this result using these two measures :
But I wanted to show same count by each category and sub_category in this percentage range but there is no relationship between my category class table and dim_product table so it looking like this
Want final result like this
Sub_category | A | B | C |
Beef | 1 | 4 | 28 |
Chicken | 3 | 6 | 55 |
Frozen Pastry | | 1 | 9 |
Frozen processed vegetable | | | 1 |
Mutton | | | 3 |
Planed Based | | 1 | 1 |
Seafood | | 1 | 3 |
Turkey | | 1 | 5 |
Total | 4 | 13 | 92 |
Help me out if you know
