Percentile Calculation

[harirao]

Hi All,

Required assistance, I have to work on Percentile Calculation
Normally Percentile works smaller value to larger Value
I have to create/calculate 75th Percentile by using a column where Percentile calculation should happen from Larger value to Smaller value.
Kindly help me on this, Thanks for your help

Regards,

[v-yiruan-msft]

Hi @harirao ，

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help anyone in the community find the solution easily if they face the similar problem with you. Thank you.

Best Regards

Rena

[v-yiruan-msft]

Hi @harirao ,

Could you please provide some sample data(exclude sensitive data) and your expected result? Thank you.

In addition, hope the following documentations can help you.

https://docs.microsoft.com/en-us/dax/percentile-exc-function-dax

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

https://stackoverflow.com/questions/30634488/calculating-percentile-in-dax

Best Regards

Rena

[harirao]

Hi,

Thanks for your response, please find the below example for your reference.
I have created 90th Percentile by using column "Actual visibility Weeks", where percentile is calculating from ascending order to descending order: Please correct me if i am work.

But I wanted to calculate 90th Percentile using ONLY descending to ascending order for the same column "Actual visibility Weeks", which ever month is Filer is used for visualization. 

[v-yiruan-msft]

Hi @harirao ,

I'm not sure if I understand your requirement... Could you please check whether the below screenshot is your expected result?

1. Create a calculated column

Neg_Actually visibility Weeks = -'Sheet1'[Actually visibility Weeks]

2. Create a measure

Percentile = ABS( PERCENTILE.INC(Sheet1[Neg_Actually visibility Weeks],0.9) )

If the above information has any wrong, please correct it. Thank you.

Best Regards

Rena

[harirao]

Hi @v-yiruan-msft,

Thanks for your response. 
Instead of creating Negative can we create a calculated colum, Larger Value to Smaller value for "Actualy Visibility weeks",  then use percentile calculation?

Regards

Hari

[v-yiruan-msft]

Hi @harirao ,

Please try to update the formula as below:

Percentile = PERCENTILE.INC(Sheet1[Actually visibility Weeks],0.1)

Best Regards

Rena

[amitchandak]

You can try using value 1/[measure] and check