DAX PERCENTILE 0.95 The percentille value must be in the range of 1/(N+1)

[Anonymous]

I have an issue.

I made a DAX Measure in SSAS in a tabular model.

PERCENTILE.EXC('ISL_TEST'[Hours],0.95)

‘ISL_TEST'[Hours] is a column where values are 0 or bigger than 0

I use a liveconnection in PBI.

When I just put the measure in a card visual, it shows a number.

When I put it in a a matrix with row field Customers I get the following error:

THE PERCENTILE value must be in the range of 1/(N+1).. N/(N+1) inclusive, Where N is the number of data values.

When I do the same thing with PERCENTILE.EXC('ISL_TEST'[Hours],0.50) hen I don't get this error.

Does somebody has a suggestion?

Thanks in advance!

[TeigeGao]

Hi @Anonymous ,

The matrix visual will create a row level filter for each line, then the function PERCENTILE.EXC will work at the context with only one row, then the function will work innormal.

Best Regards,

Teige

[Anonymous]

Ok I don't understand it,

because why does it work with percentille.ex.... 0.50 and nog with percentille.ex....095?

What do you suggest?