DAX, the COALESCE function
Don’t you hate it when a card looks like this?
Meet COALESCE
This function was introduced in March 2020 and instantly became a favourite of mine.
Although I think a more appropriate name would be ifblank!
Wrap it around your DAX statement and the Default Measure will be presented instead of that annoying blank.
This works for text like N/A or a number like 0.
Here it is:
COALESCE
(
[MyMeasure]
,
[DefaultMeasure]
)