Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

ABCXYZ Analysis

Hi,   I have been scratching my head for couple of days trying to add the XYZ into the ABC dynamic segmentation as presented in : https://www.daxpatterns.com/abc-classification/  but without succes...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , what do you want for XYZ, hope they are non-overlapping?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Oh Sorry just realized I didn't explain what I meant by ABCXYZ 🙂

 

So ABC is a basic pareto: A = 80% of Value sold, B = 15% of Value and C=5% of Value Sold

XYZ is the measure of the variability using the Coefficient of variation (CoV) with CoV = Divide(Standard Deviation, Average Sales) (Deviation and Average measured on a monthly basis)

I can do the dymamic segmentation separately using the DAX patter, no problem, but I want to be able to present the data in a matrix ABC/XYZ, so I would need to combine the both calculation together, and I am strggling with that.

I have attached a file to explain the Logic ( Sample Data) , but in summary below explain what I am trying to achieve  :

DataOutput

 

Hope it makes sense

 

Thanks