Forum Discussion
Percentile Calculation on a Measure
Anonymous , refer if this can help
https://www.goodly.co.in/calculate-percentile-in-power-bi/
or
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/763156Can you share sample data and sample output in table format?
Anonymous , refer if this can help
https://www.goodly.co.in/calculate-percentile-in-power-bi/
or
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
Can you share sample data and sample output in table format?
Thanks amitchandak . I did try with something very similar to this blog and got it working. Mainly had to create a table with all the measure values, rank it accordingly and then calculate the percentile. I will update the solution sometime.