CoalesceEmpty (MDX)

Returns the first non-empty numeric value from the parameters list.

Parameters

Return

numeric-value

Description

The function returns the first non-empty/null numeric value among the list of parameters.

Usually used to handle nulls, division by zero and/or add a default numeric value.

See Also

CoalesceNull Iif

Examples

WITH
    MEMBER [Measures].[P] AS CoalesceEmpty(null,2,3)
SELECT
    [Measures].[P] ON 0
FROM
    [Sales]

WITH
    MEMBER [Measures].[P] AS 2
SELECT
    [Measures].[P] ON 0
FROM
    [Sales]

Special Examples (errors, null, ...)

WITH
    MEMBER [Measures].[P] AS IsEmpty( CoalesceEmpty(null) )
SELECT
    [Measures].[P] ON 0
FROM
    [Sales]

WITH
    MEMBER [Measures].[P] AS True
SELECT
    [Measures].[P] ON 0
FROM
    [Sales]

CoalesceEmpty()

Error Code    : OLAP_FUNCTION_UNEXPECTED_ARGUMENT_COUNT
Error Message : CoalesceEmpty() : unexpected number of parameters '0' (expected:'2147483647,1')

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.