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
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
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
| User | Count |
|---|---|
| 133 | |
| 88 | |
| 85 | |
| 68 | |
| 64 |
