Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a rather large PBI that has data coming in through SQL and Analysis Services with 10+ queries in the query editor. I created a calculation as a measure and it works perfectly. However when I add IFERROR to eliminate the "Infinity" result my visual spins for hours and then crashes.
Is there any way around this crashing or has anyone else had the issue and been able to resolve?
Note: due to my companies data policy I am not able to provide a sample PBI file, I am hoping to just get feedback from others that have experienced the issue.
Solved! Go to Solution.
Hi @alicia_pbi
If you get infinity as a result of division then use DIVIDE() function instead of "/" operator.
Hi @alicia_pbi
If you get infinity as a result of division then use DIVIDE() function instead of "/" operator.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |