dax display as blank

[Anonymous]

hi 

i am using this dax to show my data.

but if i dont have any value the result i am getting is  blank where i want to display as 0 instead.

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please try to use the function, COALESCE inside your DAX measure.

For instance, 

last MTD Checkpoint = Coalesce ( your whole measure , 0)

Jihwan Kim

If this post helps, then please consider accept it as the solution to help the other members find it more quickly.