Hi,
I have a dynamic ABC measure that calculates top 80% of sales by product nr, further 15% and last 5% (A,B and C products)
using the Microsoft tutorial on Dynamic ABC. Howerer I am unable to perform a count of A,B,C's. Each product is coming from a supplier and is part of a subcategory of products. If i have a table with all products I can see which product is A, which B and C.
But I want to be able to have a table with all suppliers and then a measure to count how many A,B,C product I have for each supplier.
Current measure for Dynamic ABC is the following :
ABC Oms =
IF (
HASONEVALUE ( D_Vare[Varenr] ),
VAR SalesByProduct =
CALCULATETABLE (
ADDCOLUMNS (
SUMMARIZE ( F_Butikssalg, D_Vare[Varenr] ),
"@ProdSales", [Oms. kr.]
),
ALLSELECTED ( D_Vare )
)
VAR AllSales =
CALCULATE (
[Oms. kr.],
ALLSELECTED ( D_Vare )
)
VAR CurrentSalesAmt = [Oms. kr.]
VAR CumulatedSales =
FILTER (
SalesByProduct,
[@ProdSales] >= CurrentSalesAmt
)
VAR CumulatedSalesAmount =
SUMX (
CumulatedSales,
[@ProdSales]
)
VAR CurrentCumulatedPct =
DIVIDE (
CumulatedSalesAmount,
AllSales
)
VAR Result =
SWITCH (
TRUE,
ISBLANK ( CurrentCumulatedPct ), BLANK (),
CurrentCumulatedPct <= 0.8, "A",
CurrentCumulatedPct <= 0.95, "B",
"C"
)
RETURN
Result
)
