DAX Function Guide

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.

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.

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.