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.

Sarangaku's avatar
Sarangaku
Frequent Visitor
2 years ago

Thank you for the response, but in my case ABC Classification is a measure, not a column

Anonymous's avatar
Anonymous
Not applicable
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.