NORM.DIST
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Returns the normal distribution for the specified mean and standard deviation.
Syntax
NORM.DIST(X, Mean, Standard_dev, Cumulative)
Parameters
| Term | Definition |
|---|---|
| X | The value for which you want the distribution. |
| Mean | The arithmetic mean of the distribution. |
| Standard_dev | The standard deviation of the distribution. |
| Cumulative* | A logical value that determines the form of the function. If cumulative is TRUE, NORM.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function. |
Return value
The normal distribution for the specified mean and standard deviation.
Remarks
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Example
EVALUATE { NORM.DIST(42, 40, 1.5, TRUE) }
Returns
| [Value] |
|---|
| 0.908788780274132 |