Quartile split based on segmented data

[Anonymous]

Hi Power BI community,

I am working with some data that has been simplified in the below table.

What I am trying to do is split the data into quartiles based on a selected product. So if Product 2 is selected in a slicer/dropdown, what I would like is the sales data for that product split into 4 quartiles i.e. quartile 1 is the best performing countries in terms of Avg Profit (per unit), and quartile 4 the worst performing countries.. It's possible I may have certain products with sales in less than 4 countries, in which case they can go into the relevant quartiles in order from 1 to 2 to 3.

I would like to use the quartiles as visual filters after.

I've read several threads but can't figure out how I might do this, so any guidance would be appreciated.

Product	Country	Avg Profit (per unit)
Product 1	Country 1	xyz
Product 1	Country 2	xyz
Product 1	Country 3	xyz
Product 1	Country 4	xyz
Product 1	Country N	xyz
Product 2	Country 1	xyz
Product 2	Country 3	xyz
Product 2	Country 5	xyz
Product 2	Country 9	xyz
Product 2	Country N	xyz
Product 5	Country 3	xyz
Product 5	Country 7	xyz
Product 5	Country 8	xyz
Product 5	Country 11	xyz
Product 5	Country N	xyz
Product N	Country N	xyz

[V-lianl-msft]

Hi @Anonymous ,

You can refer to this thread:https://community.powerbi.com/t5/Desktop/quartile-ranking/m-p/560850 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

This sounds like Dynamic ABC classification although it sounds like you want dynamic ABCD classification:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-ABC-Classification/m-p/479146#M180