Forum Discussion
Sarangaku
2 years agoFrequent Visitor
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 %] > ...
- Anonymous2 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.
MattAllington
2 years agoCommunity Champion
Try this
SUMX(productsTableName, [Total Qty Cumulative %]<= 0.8, 1)
- Sarangaku2 years agoFrequent Visitor