It’s a logical DAX function that used to returns the first expression that does not evaluate to BLANK. If all expressions evaluate to BLANK, BLANK is returned.
expression – Any DAX expression that returns a scalar expression.
Add one measure to understand the working of Coalesce DAX-
Coalesce_DAX = COALESCE( BLANK() , "No value")
As you can see in above DAX, first expression value is blank, so it will return second expression value. See the output in below screen shot.
Add another measure and write below DAX code-
Coalesce_DAX = COALESCE( 12345 , "No value")
Here first expression value is not blank so it will return first expression value, see the below output-
Add one more measure and write below DAX code-
Coalesce_DAX = COALESCE( BLANK() , BLANK())
Here, as both expression values are blank, the function will consequently return a blank result. Please refer to the output for confirmation.
Refer more DAX functions: DAX functions
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our Contact form , we will revert to you asap.