Forum Discussion
Numbers are displayed as infinity
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.
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
1 Reply
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