10% of population groups with filters

[precio_96]

Hi all,

I am working on proyect where I need to group the data on 10 groups with same amount of cases of the overall population, the problem comes when I try to filter something the cases keep filtering by the total amount of the population instead of regrouping and keeping the 10% of the population in each group.

What I already done is to create an Index column and divide it by the total amount of the population, and with this create a column of groups...the problem will come when anyone filter it.

So here is an example of my data 

Data 

So basically the idea is to keep groups of 10% of total population and be able to filter it by period and product.

If anyone can help to create this dynamic groups will be great!

Thanks in advance and have a wonderful day.

Regards,

Pablo

[v-lionel-msft]

Hi @precio_96 ,

Like this? Please refer to my .pbix file.

Best regards,
Lionel Chen

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

[precio_96]

Hi Lionel Chen,

Thanks for publishing a solution, but unfortunately this is not exactly the expected result. We should get only 10 groups with 10% of the population that is actually filtered. And the final idea will be to show the 10 groups, with how many population they are commulating until each group.

Please let me know your thoughts and again thank you so much for giving an answer.

Best regards,

Pablo

[v-lionel-msft]

Hi @precio_96 ,

Divide the filtered data into 10 groups (G0-G9)?

Best regards,
Lionel Chen

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

[precio_96]

Hi Lionel Chen,

Hope you are doing well.

This will be good, but the idea is not to keep the CreditsID on the list, only the groups.

Do let me know your thoughts.

Happy weekend and best regards,

Pablo

[amitchandak]

@precio_96 , not exact same. But see if these can help

Top 80/20 , percent /percentile
https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/
https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459
https://finance-bi.com/power-bi-pareto-analysis/
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/td-p/763156

or

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization