Strange error n NORM.S.INV function DAX when creating a column.

[Wisselaar]

I'm trying to add a calculated column in Power BI modeler with DAX. In a column X I have a probability, say 0.08 or 0.01 For that column X I'd like to add the calculation of NORM.S.INV(mytable[columnX]) I get an error: An argument of function 'NORM.S.INV' has the wrong data type or the result is too large.

Datatype is okay, though.

When I enter NORM.S.INV(0.08) or some other value of column X this works fine. Same table in Excel with this function works fine as well.

The same issue occurs with a measure. As soon as it has only a single value, it returns the same error.

[Anonymous]

Such a question can't be answered without actually showing us the file.

The only thing one can say is... make sure the data type of the column is correct. Also, since the normal distribution has a support which is the whole real line, for some values the number returned from the inverse of the distribution function can be too large, indeed.

Best
D