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
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Fabric Community Update - November 2024
Find out what's new and trending in the Fabric Community.
We want your feedback!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
