CHISQ.INV.RT is a DAX function that returns the inverse of the right-tailed probability of the chi-squared distribution, used to validate hypotheses by comparing observed and expected results.
CHISQ.INV.RT(
Probability,
Deg_freedom
)| Argument | Properties | Description |
|---|---|---|
| Probability | A probability associated with the chi-squared distribution. | |
| Deg_freedom | The number of degrees of freedom. |
Returns the inverse of the right-tailed probability of the chi-squared distribution.
If either argument 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.
Given a value for probability, CHISQ.INV.RT seeks that value x such that CHISQ.DIST.RT(x, deg_freedom) = probability. Thus, precision of CHISQ.INV.RT depends on precision of CHISQ.DIST.RT. CHISQ.INV.RT uses an iterative search technique. If the search has not converged after 64 iterations, the function returns the #N/A error value.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Other functions related to CHISQ.INV.RT are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy