# NORM.S.INVDAX Function (Statistical)

Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.

## Syntax

NORM.S.INV ( <Probability> )
Parameter Attributes Description
Probability

A probability corresponding to the normal distribution.

## Return values

Scalar A single decimal value.

The inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.

» 3 related functions

## Examples

```--  NORM.INV returns the inverse of the normal distribution
--  for the specified mean and standard deviation
--
--  NORM.S.INV returns the inverse of the standard normal distribution
--  (has a mean of zero and a standard deviation of one)
--
--  https://en.wikipedia.org/wiki/Normal_distribution
DEFINE
TABLE SampleData    = { 2, 4, 4, 4, 5, 5, 7, 9 }
VAR Mean            = AVERAGE ( SampleData[Value] )
VAR StandardDev     = STDEV.S ( SampleData[Value] )
VAR Percs           = GENERATESERIES ( 0.05, 0.99, 0.05 )
VAR CumulativeTrue  = TRUE   -- Cumulative distribution function
VAR CumulativeFalse = FALSE  -- Probability density function
EVALUATE
SELECTCOLUMNS (
Percs,
"Probability %", [Value],
"Inv. Normal Distr.",          -- Probability density function
FORMAT (
NORM.INV ( [Value], Mean, StandardDev ),
"#,0.00000"
),
"Inv. Standard Normal Distr.", -- Probability density function
FORMAT (
NORM.S.INV ( [Value] ),
"#,0.00000"
)
)
```
Probability % Inv. Normal Distr. Inv. Standard Normal Distr.
5.00% 1.48316 -1.64485
10.00% 2.25993 -1.28155
15.00% 2.78401 -1.03643
20.00% 3.20054 -0.84162
25.00% 3.55788 -0.67449
30.00% 3.87878 -0.52440
35.00% 4.17615 -0.38532
40.00% 4.45832 -0.25335
45.00% 4.73132 -0.12566
50.00% 5.00000 0.00000
55.00% 5.26868 0.12566
60.00% 5.54168 0.25335
65.00% 5.82385 0.38532
70.00% 6.12122 0.52440
75.00% 6.44212 0.67449
80.00% 6.79946 0.84162
85.00% 7.21599 1.03643
90.00% 7.74007 1.28155
95.00% 8.51684 1.64485

## Related functions

Other related functions are:

Last update: Aug 3, 2024     » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber

Microsoft documentation: https://docs.microsoft.com/en-us/dax/norm-s-inv-dax

# Context Transition

This function performs a Context Transition if called in a Row Context. Click to read more.

# Row Context

This expression is executed in a Row Context. Click to read more.

# Not recommended

The use of this function is not recommended. See Remarks and Related functions for alternatives.

# Not recommended

The use of this parameter is not recommended.

# Deprecated

This function is deprecated. Jump to the Alternatives section to see the function to use.

# Volatile

A volatile function may return a different result every time you call it, even if you provide the same arguments. Click to read more.

# Deprecated

This parameter is deprecated and its use is not recommended.

# DirectQuery compatibility

Limitations are placed on DAX expressions allowed in measures and calculated columns.
The state below shows the DirectQuery compatibility of the DAX function.

### Contribute

Want to improve the content of NORM.S.INV? Did you find any issue?
Please, report it us! All submissions will be evaluated for possible updates of the content.