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

The CHISQ.INV.RT function (DAX) is a statistical type of DAX function that returns the inverse of the right-tailed probability of the chi-squared distribution.

CHISQ.INV.RT Formula Syntax


How do you use the CHISQ.INV.RT function?

This function is used if you wanted to compare actual results with your expected results to decide whether your original hypothesis is valid or not.

The CHISQ.INV.RT function has two arguments: the probability associated with the chi-squared distribution, for which we want to find the value of x and the number of degrees of freedom which must be a positive integer.

Related Blog Posts

Related Support Forum Posts

SUMX not calculating correctly
DATEADD within SUMX returning 0 or blank
Allselected+values+sumx can’t be combined

Considerations when using the CHISQ.INV.RT function

If deg_freedom < 1, CHISQ.INV.RT returns the #NUM! If either of the two arguments mentioned above is nonnumeric, CHISQ.INV.RT returns the #VALUE! error value.

If probability < 0 or probability > 1, CHISQ.INV.RT returns the #NUM! error value. If deg_freedom is not an integer, it is rounded. If deg_freedom < 1, CHISQ.INV.RT returns the #NUM! error value.

Related Video Tutorials

Formula examples using the CHISQ.INV.RT function

=CHISQ.INV.RT( 0.1, 2 )

=CHISQ.INV.RT( 0.5, 1 )

=CHISQ.INV.RT( 0.75, 1 )

Related Course Modules

Center of Excellence


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