NORM.S.DIST

Updated on

NORM.S.DIST is a DAX function that returns the standard normal distribution with a mean of zero and a standard deviation of one.

Syntax

NORM.S.DIST(
   Z,
   Cumulative
)
Argument Properties Description
Z The value for which you want the distribution.
Cumulative 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.

Return Values

The standard normal distribution (has a mean of zero and a standard deviation of one.

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.S.DIST(1.333333, TRUE) }

Returns

[Value]
0.908788725604095

Other functions related to NORM.S.DIST are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/norm-s-dist-function-dax

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy