CONFIDENCE.NORM - Daxplained

CONFIDENCE.NORM is a DAX function that returns the confidence interval for a population mean using a normal distribution.

Syntax

CONFIDENCE.NORM(
   Alpha,
   Standard_dev,
   Size
)

Argument	Properties	Description
Alpha		The significance level used to compute the confidence level. The confidence level equals 100*(1 – alpha)%, or in other words, an alpha of 0.05 indicates a 95 percent confidence level.
Standard_dev		The population standard deviation for the data range and is assumed to be known.
Size		The sample size.

A range of values

If any argument is nonnumeric, CONFIDENCE.NORM returns the #VALUE! error value.
If alpha ≤ 0 or alpha ≥ 1, CONFIDENCE.NORM returns the #NUM! error value.
If standard_dev ≤ 0, CONFIDENCE.NORM returns the #NUM! error value.
If size is not an integer, it is rounded.
If size < 1, CONFIDENCE.NORM returns the #NUM! error value.
If we assume alpha equals 0.05, we need to calculate the area under the standard normal curve that equals (1 – alpha), or 95 percent. This value is ± 1.96. The confidence interval is therefore:

$\overset{―}{x} \pm 1.96 (\frac{σ}{\sqrt{n}})$
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Empty

Other functions related to CONFIDENCE.NORM are:

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