Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |