PERCENTILE.INC percentile value should be between 0 and 1

[JVidal]

Good morning, 

I would like to calculate the percentiles of my sales column, but I am unable to achieve so with the PERCENTILE.INC or PERCENTILEX.INC functions.

The function will not return an error while creating, but I cannot display when I put the measure in a table with the following error message:

MdxScript(Model) (24, 39) Calculation error in measure '03-Products'[Percentile025]: The percentile value should be in the range 0..1, inclusive.

The way I am using the formula is as follows:

Percentile025 = PERCENTILE.INC(Table[Sales];0,25)

What is wrong here? All the information I have searched for this point to me using the function correctly.

Thank you

Kind regards,

[v-juanli-msft · Accepted solution]

Hi @JVidal 

As tested, this formula in a measure is incorrect

Percentile025 = PERCENTILE.INC(Table[Sales],0,25)

When i use the following formula, it shows correctly

Measure = PERCENTILE.INC(Sheet1[sales],0.25)

For the Syntax PERCENTILE.INC(<column>, <k>),

k must be between 0 and 1, otherwise PERCENTILE.INC will return error.

If k is zero or blank, percentile rank of 1/(n+1) returns the smallest value. If zero, it is out of range and an error is returned.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.