DAX

DAX COALESCE

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] )