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
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership