cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## Finding the Percentile of a Measure

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.

1 ACCEPTED SOLUTION
Super User

Hi,

You can use PERCENTILEX functions to get this:

Measure 23 = PERCENTILEX.INC(ALL('Table (32)'[Month]),[Measure 22],0.75)

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!

Proud to be a Super User!

Super User

Hi,

You can use PERCENTILEX functions to get this:

Measure 23 = PERCENTILEX.INC(ALL('Table (32)'[Month]),[Measure 22],0.75)

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!

Proud to be a Super User!