Hello,
I am trying to find the Percentile (75%) of the below table for the colmun "Order Lines/Order".
All the columns (except the month) are measures.
I am familiar with the proper functions for the PRECENTILE but these require tables and not measures.
Could you please advise?
1 ACCEPTED SOLUTION
Hi,
You can use PERCENTILEX functions to get this:
Measure 23 = PERCENTILEX.INC(ALL('Table (32)'[Month]),[Measure 22],0.75)
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Hi,
You can use PERCENTILEX functions to get this:
Measure 23 = PERCENTILEX.INC(ALL('Table (32)'[Month]),[Measure 22],0.75)
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
