CHISQ.INV Function (DAX)

How does the CHISQ.INV function (DAX) work?

The CHISQ.INV function (DAX) returns the inverse of the left-tailed probability of the chi-squared distribution.

CHISQ.INV Formula Syntax

CHISQ.INV(
     probability,deg_freedom
)

How do you use the CHISQ.INV function?

The chi-squared distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television.

Related Blog Posts

Related Support Forum Posts

Understanding DAX Formula
Developing Complex Dax functions

Considerations when using the CHISQ.INV function

Things to remember about the CHISQ.INV Function.

If argument is nonnumeric, CHISQ.INV returns the #VALUE! error value.

If probability < 0 or probability > 1, CHISQ.INV returns the #NUM! error value.

If deg_freedom is not an integer, it is rounded.

If deg_freedom < 1 or deg_freedom > 10^10, CHISQ.INV returns the #NUM! error value.

Related Video Tutorials

Formula examples using the CHISQ.INV function

=CHISQ.INV(0.93,1)

=CHISQ.INV(0.6,2)

=CHISQ.INV( 0.5, 1 )

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.