Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
ccluzel
Frequent Visitor

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

Anyone has any idea ?

 

Thanks

v-yalanwu-msft
Community Support
Community Support

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.

 

 

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

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.