2 Level Percentile on Measures

[esthony]

Hi,

Good day. Need help on creating a measure for filtering data. here is the scenario, On my data i need to display the records above on 95th percentile. after on the filtered data i to filter again the 95th percentile and present those data on matrix table. I am able to this but I need to tag the record if it is a 95th of 95th percentile by adding a custom column. Is this possible to make this via measure? so i can make dynamic parameters on computing percentile. what is the best approach to achieve this.

here is the sample pbix. https://1drv.ms/u/s!AgJ5O-xAOwJ2hy3QhNzyoif_Rx5h?e=a9aPwM 

sample of what i have done.

Thanks,

Anthony

[esthony]

This is a big help and i think this is a better approach on what i did. I just need to figure out how to get .8 after filtering the .8. 

Thanks a lot.

Esthony

[amitchandak · Accepted solution]

@esthony , I have done similar work using window function if that can help

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

How to use numeric Measure

Power BI Window function- TOP N% with Others: https://youtu.be/rQElaRoPbUA