Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[christophe cluzel]

Hi I am trying to create a dynamic segmentation ABC/XYZ following the tutorial : https://www.daxpatterns.com/abc-classification/I can without problem create a ABC segmentation and a XYZ segmentation, but I need to have the both at the same time.
for context :
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, but in summary below explain what I am trying to achieve:

Hope it makes sense
 
Thanks 

[christophe cluzel]

Hi, I was wondering if anyone has any idea to help

Thanks

——————————
christophe cluzel
RG45 6NN
——————————
——————————————-