Reply
ccluzel
Frequent Visitor
Partially syndicated - Outbound

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

 

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

 

Thanks

5 REPLIES 5
ccluzel
Frequent Visitor

Syndicated - Outbound

Anyone has any idea ?

 

Thanks

v-yalanwu-msft
Community Support
Community Support

Syndicated - Outbound

Hi, @ccluzel ;

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

vyalanwumsft_0-1649381284901.png

Then change the Total as count of.

vyalanwumsft_2-1649381316239.png

The final output is shown below:

vyalanwumsft_4-1649381347445.png


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.

 

 

Syndicated - Outbound

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
Super User
Super User

Syndicated - Outbound

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Syndicated - Outbound

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  :

DataDataOutputOutput

 

Hope it makes sense

 

Thanks 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)