Calculated Table for Percentile Values by Category

Question

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 · Answer

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
&nbsp;
Power BI ABC Analysis using Window function, Dynamic Segmentation: https://youtu.be/A8mQND2xSR4
&nbsp;
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/459https://finance-bi.com/power-bi-pareto-analysis/

Forum Discussion

Calculated Table for Percentile Values by Category

1 Reply

Related content

Calculate percentile between tables

Calculate percentile from measure

Calculating percentiles of a measure

Calculate Average per category

Calculating Percentiles in PowerBI