Identify the right value to fulfill different percentage range

[Anonymous]

Below example table, includes the age of 10 people. I want to find out what age value to cover 90% of people. The expected result is age 20 which covers 9 people from B to J. How to use DAX functions to find the right age value?  

Thanks

Clement

[tackytechtom · Accepted solution]

Hi @Anonymous ,

How about this:

Here the DAX code:

TomsPercentile90Measure = 
VAR _percentile = PERCENTILE.INC ( Table12[Age], 0.90 )
RETURN
CALCULATE ( 
    MAX ( Table12[Age] ),
    Table12[Age] <= _percentile
)

Let me know, if this works for you 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Anonymous]

Hi Tom,

Thanks a lot. It works perfectly.

Best regards

Clement