Calculated Table for Percentile Values by Category

[GlassShark1]

I've got a source table 'Rent_Tbl' that has a category 'Bedrooms' where values range from 0 to 9. ListingPrice contains the rental cost for each ID (UPRN).

What I want to do is to create a table to calculate the 30th percentile values for 1 bed, 2 bed, 3 bed etc. I can then do things like count the number of properties with rental costs within the 30th percentile.

I originally created a measure to calculate percentile that took number of bedrooms and percentile as input through slicers, but when i wanted to do the above, PBI can't do it because it wants the values in a column. I'm a bit lost with calculated tables.

Thanks

Any help appreciated. Thanks 🙂

[amitchandak]

@GlassShark1 , check if this can help

Power BI Window: Pareto Analysis Again, 80% of sales, Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw

Power BI ABC Analysis using Window function, Dynamic Segmentation: https://youtu.be/A8mQND2xSR4

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/