Forum Discussion

Sarangaku's avatar
Sarangaku
Frequent Visitor
2 years ago
Solved

Count items in ABC Classification

I have created ABC Classification for a report using the below measure   ABC Classfication = SWITCH (     TRUE(),     [Total Qty Cumulative %]<= 0.8, "A Class",     [Total Qty Cumulative %] >  ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Sarangaku 

    Measure cannot be placed in the X-axis of the clustered column chart.     You need to change ABC Classification to a calculated column.

    ABC Classfication = SWITCH (
    TRUE(),
    [Total Qty Cumulative %]<= 0.8, "A Class",
    [Total Qty Cumulative %] >  0.8 && [Total Qty Cumulative %]<= 0.95, "B Class",
     "C Class"
    )

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thank you for your prompt reply! MattAllington  Ashish_Mathur 

Hi Sarangaku 

 

After calculating the categories, you can use the following dax to calculate how many products each category corresponds to.

Measure = 
VAR _calss = SELECTEDVALUE('Table'[ABC Classfication])
RETURN
CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[ABC Classfication] = _calss))

 

 

Result:

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.