## How does the NORM.DIST function (DAX) work?

The NORM.DIST function (DAX) returns the normal distribution for the specified mean and standard deviation.

## NORM.DIST Formula Syntax

NORM.DIST(
X, Mean, Standard_dev, Cumulative
)

## How do you use the NORM.DIST function?

This function will calculate the probability that variable x falls below or at a specified value. That is, it will calculate the normal probability density function or the cumulative normal distribution function for a given set of parameters.

## Related Support Forum Posts

Normal Distribution Curve
Dax Calculation question
Dax not working

## Considerations when using the NORM.DIST function

The NORM.DIST uses the following arguments:

1. X (required argument) – This is the value for which we wish to calculate the distribution.
2. Mean (required argument) – The arithmetic mean of the distribution.
3. Standard_dev (required argument) – The standard deviation of the distribution.
4. Cumulative (required argument) – This is a logical value. It specifies the type of distribution to be used: TRUE (Cumulative Normal Distribution Function) or FALSE (Normal Probability Density Function).

We can use 1 for TRUE and 0 for FALSE when entering the formula.

## Formula examples using the NORM.DIST function

EVALUATE { NORM.DIST(42, 40, 1.5, TRUE) }

=NORM.DIST(A2,A3,A4,FALSE)

=NORM.DIST(A2,A3,A4,TRUE)

## Related Course Modules 