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 %] >  ...
  • 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.