Percentile, Quantile, Top N ?

[Xavier]

Hello everybody,

This is my first post.

I have a basic Employees Excel Sheet with two columns (Matricule, Annual Salary).

I would like to calculate the salary above which there is a percentage of employees. For example, the value of the salary above which the top 10% of employees are paid.

Thank you very much

[harshnathani]

Hi @Xavier ,

You can use the formula

TOP 10 = PERCENTILE.INC(ALL('Table'),.90)

This will give you the threshold or 90percentile value or people who are in top 10 percentile salary.

You can also refer the post

https://community.powerbi.com/t5/Desktop/Calculating-the-percentile-for-a-set-of-data/td-p/250581

https://community.powerbi.com/t5/Desktop/Dynamic-calculation-of-percentiles/td-p/458233

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)