Forum Discussion
2 Level Percentile on Measures
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 , 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
2 Replies
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
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
