ABCXYZ Analysis

Question

Hi,&nbsp;I have been scratching my head for couple of days trying to add the XYZ into the ABC dynamic segmentation as presented in :&nbsp;https://www.daxpatterns.com/abc-classification/&nbsp; but without success.&nbsp;Has anyone has a way to create a dynamic ABCXYZ dynamic segmentation which mimic what is presented in the DAXpattern website ?&nbsp;Thanks

amitchandak · Answer

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

anonymous · Answer

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

v-yalanwu-msft · Answer

Hi,&nbsp;Anonymous&nbsp;;
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 WuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;
&nbsp;