topic Error at Chart that have CHISQ.INV.RT Formula in DAX Commands and Tips

Error at Chart that have CHISQ.INV.RT Formula

Anonymous — Tue, 22 Dec 2020 10:03:15 GMT

Hi, how to solve this kind of error, it is said that the problem is because of the parameter of function CHISQ.INV.RT.

I have the chart "Lower and Upper" that use CHISQ.INV.RT formula, when I filter the result, the answer is correct and without error. It shows like this:-

But if I click at the chart, either std or mean. It will show errors at lower and upper.

Re: Error at Chart that have CHISQ.INV.RT Formula

amitchandak — Tue, 22 Dec 2020 10:30:08 GMT

Anonymous , can you share the formula used?

Re: Error at Chart that have CHISQ.INV.RT Formula

Anonymous — Tue, 22 Dec 2020 10:46:30 GMT

Lower(M) = (1/(2*platform[Beta(M)]))*CHISQ.INV.RT(0.95,(2*platform[Alpha(M)]))

Upper(M) = (1/(2*platform[Beta(M)]))*CHISQ.INV.RT(0.05,(2*platform[Alpha(M)]))

Re: Error at Chart that have CHISQ.INV.RT Formula

daxer-almighty — Tue, 22 Dec 2020 11:21:02 GMT

Hi there. If you check the documentation (dax.guide/chisq.dist.rt) for the function, you'll see this:

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.

It might just be that for some of your inputs the search does not converge?