- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Anyone has any idea ?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 :
Data
Output
Hope it makes sense
Thanks

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-20-2025 09:06 AM | |||
07-09-2024 04:22 AM | |||
07-15-2024 01:33 AM | |||
Anonymous
| 11-11-2024 04:20 AM | ||
07-08-2024 06:26 AM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |