COALESCE DAX Function

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.

Syntax

COALESCE(<expression>, <expression>…)

Parameters

expression – Any DAX expression that returns a scalar expression.

Example -1:

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.

Example-2

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-

Example-3

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.