Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Returns the first expression that does not evaluate to BLANK. If all expressions evaluate to BLANK, BLANK is returned.
Syntax
COALESCE(<expression>, <expression>[, <expression>]…)
Parameters
| Term | Definition |
|---|---|
expression |
Any DAX expression that returns a scalar expression. |
Return value
A scalar value coming from one of the expressions or BLANK if all expressions evaluate to BLANK.
Remarks
Input expressions may be of different data types.
Example 1
The following DAX query:
EVALUATE { COALESCE(BLANK(), 10, DATE(2008, 3, 3)) }
Returns 10, which is the first expression that does not evaluate to BLANK.
Example 2
The following DAX expression:
= COALESCE(SUM(FactInternetSales[SalesAmount]), 0)
Returns the sum of all values in the SalesAmount column in the FactInternetSales table, or 0.
This can be used to convert BLANK values of total sales to 0.