Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 |