Forum Discussion
Count items in ABC Classification
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.
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.
Thank you for the response, but in my case ABC Classification is a measure, not a column
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.
