Count items in ABC Classification

[Sarangaku]

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

[Anonymous]

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]

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

[Anonymous · Accepted solution]

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.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[MattAllington]

Sorry, my bad

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

[MattAllington]

Try this

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

[Sarangaku]