NullToZero in Power BI and Tabular
Null and zero typically have different semantics, where null indicates an unknown or missing value while zero is an explicit value. Sometimes, however, you want to show nulls as zeros. For example, an insurance company might want to show 0 claims instead of a blank value. By default, when a DAX filter doesn’t find any rows, the formula returns null (BLANK in DAX). For example, this Claims Count measure will return null when no claims match the report filters.
Claims Count = DISTINCTCOUNT(FactClaims[UniqueClaimNumber])
How do we show nulls as zeros?
The easiest and fastest way is to simply append zero.
Claims Count = DISTINCTCOUNT(FactClaims[UniqueClaimNumber]) + 0
Note that the storage engine is optimized to eliminate empty spaces so converting measures to zero can impact performance negatively. In addition, by default, reports remove dimension members with empty measures. This won’t happen if measures return zero.
