Error at Chart that have CHISQ.INV.RT Formula

[Anonymous]

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. 

[daxer-almighty]

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?

[amitchandak]

@Anonymous , can you share the formula used?

[Anonymous]

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)]))