CHISQ.DIST - Daxplained

CHISQ.DIST is a DAX function that returns the chi-squared distribution, commonly used to study variation in percentages across samples.

Syntax

CHISQ.DIST(
   X,
   Deg_freedom,
   Cumulative
)

Argument	Properties	Description
X		The value at which you want to evaluate the distribution.
Deg_freedom		The number of degrees of freedom.
Cumulative		A logical value that determines the form of the function. If cumulative is TRUE, CHISQ.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.

The chi-squared distribution.

If x or deg_freedom is nonnumeric, an error is returned.
If deg_freedom is not an integer, it is rounded.
If x < 0, an error is returned.
If deg_freedom < 1 or deg_freedom > 10^10, an error is returned.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

The following DAX query,

EVALUATE { CHISQ.DIST(2, 2, TRUE) }

Returns

[Value]
0.632120558828558

Other functions related to CHISQ.DIST are:

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