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 %] >  0.8 && [Total Qty Cumulative %]<= 0.95, "B Class",
     "C Class"
    )

This will dynamically classify products into the above classes; I need to count many items in each class and show in a clustered column chart to show that insight, Tried many ways but didn't work, please help

 

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.

7 Replies

  • MattAllington's avatar
    MattAllington
    Community Champion
    2 years ago

    Try this

       SUMX(productsTableName, [Total Qty Cumulative %]<= 0.8, 1)

  • MattAllington's avatar
    MattAllington
    Community Champion
    2 years ago

    Sorry, my bad

    SUMX(productsTableName, if([Total Qty Cumulative %]<= 0.8, 1))

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

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