ABCXYZ Analysis

[ccluzel]

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

Has anyone has a way to create a dynamic ABCXYZ dynamic segmentation which mimic what is presented in the DAXpattern website ?

Thanks

[ccluzel]

Anyone has any idea ?

Thanks

[v-yalanwu-msft]

Hi, @ccluzel ;

May be you could use matrix visual. then ABC as rows, XYZ as column , and total as value.

Then change the Total as count of.

The final output is shown below:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ccluzel]

Thanks, but I need the ABCXYZ calculation to be done in Power BI, What I have is only the fact data with the sales per month

Thanks

[amitchandak]

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

[ccluzel]

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