Calculate PERCENTILE.EXC off a measure?

[Anonymous]

Hi, 

I need to create a measure off a measure.

This is the 1st measure that I create in order to get the average days. 

Days MEAN = Average('Table1'[Days]) 

I need to create a 2nd measure to calculcate the percentile using PERCENTILE.INC function.

It turns out that PERCENTILE.EXC(column, kth percentile) only allows columns to as the parameter. 

Could anyone please let me know what I can use the 1st measure "Days MEAN" to calculate the percentile by using PERCENTILE.EXC?  

Thank you in advance for the supports!

[v-danhe-msft]

Hi @Anonymous ,

Could you have tried with PERCENTILEX.EXC function to have a try?

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

Regards,

Daniel He