Error: The result of function 'NORM.DIST' is too large (overflow).

[Anonymous]

Hi there,

I recently used the fucntion NORM.DIST in PowerBI and received the below error " The result of function 'NORM.DIST' is too large (overflow)"

Has anyone come across this before and know how to fix this?

Thanks

Julia

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

NORM.DIST is the formula like the following image:

And in DAX, NORM.DIST = NORM.DIST(X, Mean, Standard_dev, Cumulative). 

So you could get this : x-->X, μ-->Mean, σ-->Standard_dev

According to the formula, you need to check if your Standard_dev is 0 or blank.

[Anonymous]

Thanks - I actually have an error in the mean value in the formula (using the "/" equation) so I have switched to DIVIDE formula and that works now.