Trying to create percentiles based on Rank?

[morrowchristian]

I want to create a column with DAX that will get the top 10%, middle 80%, and bottom 10% of data based on user activity from a user table. The name of the table is UserEmailMapping and the column I ranked and want the percentages from is called TotalUserActivity. I want to be able to put this into a chart so I can always see who is in the top 10%, middle 80%, etc of users based on Activity. Any idea how I could do that with DAX?

[harshnathani]

Hi @morrowchristian ,

You can have a look at the solution

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

https://community.powerbi.com/t5/Desktop/Calculate-percentile-by-group/td-p/478239

https://community.powerbi.com/t5/Desktop/Calculating-Percentile-on-Measure/td-p/548750

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

Also please share sample data and expected output.

Please see this post regarding How to Get Your Question Answered Quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

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