Marco Russo and Alberto Ferrari take us through the COALESCE()
function in DAX:
COALESCE accepts multiple arguments and returns the first argument that is not blank. If the first argument is blank, COALESCE returns the value provided by the expression in the second argument, and so on. If all the arguments are blank, COALESCE returns blank as well.
Good for SQL users, who should already be familiar with the function.