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?

This function is used to study the variations in the percentage of a data across samples.

Related Blog Posts

Related Support Forum Posts

FILTER( ALL(…and filtering with other columns
DATEADD within SUMX returning 0 or blank
If Is Blank in Countrows card visual

Considerations when using the CHISQ.INV function

If the argument is nonnumeric in nature, the CHISQ.INV function will return a #VALUE! Error message. If probability < 0 or probability > 1, CHISQ.INV will return a #NUM! error value.  

If the 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.