The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 🙂
@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/
User | Count |
---|---|
109 | |
82 | |
74 | |
53 | |
49 |
User | Count |
---|---|
133 | |
97 | |
94 | |
71 | |
69 |