NORM.S.DIST Function (DAX)

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

The NORM.S.DIST function (DAX) returns the standard normal distribution (has a mean of zero and a standard deviation of one).

NORM.S.DIST Formula Syntax

NORM.S.DIST(
     Z, Cumulative
)

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

Use this function in place of a table of standard normal curve areas. The NORM.S.DIST function can be used to determine the probability that a random variable that is standard normally distributed would be less than 0.5.

Related Blog Posts

Related Support Forum Posts

Dax Calculation question
Dax not working
DAX Buffer Calculation Query

Considerations when using the NORM.S.DIST function

The NORM.S.DIST function syntax has the following arguments:

  • Z Required. The value for which you want the distribution.
  • Cumulative Required. Cumulative is a logical value that determines the form of the function. If cumulative is TRUE, NORMS.DIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.

Related Video Tutorials

Formula examples using the NORM.S.DIST function

EVALUATE { NORM.S.DIST(1.333333, TRUE) }

=NORM.S.DIST(1.333333,FALSE)

=NORM.S.DIST(C5,FALSE)

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formula Reference Guide