Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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?
@Anonymous , can you share the formula used?
User | Count |
---|---|
53 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
80 | |
57 | |
40 | |
19 | |
10 |