Numbers are displayed as infinity

[Tome_05]

I am always grateful for your help.

I am displaying a numerical value on the card, but the numerical value is displayed as infinity. I would like to write this as 0, but please tell me how to set it and how to do it.

thank you.

[danextian · Accepted solution]

Hi @Tome_05 ,

When dividing a number by zero, DAX returns infinity.  This isn't the case if you use DIVIDE instead of  " / " to perform a division. The last argument in DIVIDE returns an alternate result when division by zero results in an error.

When not provided, the default value is BLANK().  https://docs.microsoft.com/en-us/dax/divide-function-dax