New Card Visual - Error when reference label divide by 0

[lwright]

When one of my reference labels has a divide by 0 error it either blanked out the entire visual (even other measures that were unrelated) and/or blanked out the customisable visual options entirely for the visual. I tried an IFERROR in the visual and this didn't work, in the end I did an IF statement saying if 'Denominator' = 0 then 0 else DIVIDE 'etc' (This measure is a DIVIDE function for percentage change)

 

Regular output (with IF statement)

Blank output (when IF removed)

[Anonymous]

Hi @lwright ,

Unfortunately, I have made some attempts and have not been able to reproduce your problem. Can you provide me with your sample data? Usually, we use division to avoid a denominator of zero. If the value is wrong, you can redefine it by this function.

Best regards,
Community Support Team_ Scott Chang