iferror in measure crashing my canvas

[alicia_pbi]

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.

[Mariusz · Accepted solution]

Hi @alicia_pbi 

If you get infinity as a result of division then use DIVIDE() function instead of  "/" operator.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn