Events
31 Mar, 23 - 02 Apr, 23
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayNORM.DIST
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Returns the normal distribution for the specified mean and standard deviation.
DAX
NORM.DIST(X, Mean, Standard_dev, Cumulative)
| 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. |
The normal distribution for the specified mean and standard deviation.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
DAX
EVALUATE { NORM.DIST(42, 40, 1.5, TRUE) }
Returns
| [Value] |
|---|
| 0.908788780274132 |