Max (MDX)

Returns the max value of the specified set expression.

Parameters

Name	Type	Cardinality	Default value
	set-expression	one
	value-expression	zero-one

Return

value

Description

The max function calculates the max value of the non-empty cells.

1) A value expression is specified.

When the value expression is specified, the measure is evaluated over the set and its max value is returned.

2) A value expression is not specified.

If a value expression is not specified, the measure is taken from the current context.

Examples

Max(set)

Max Amount
3.0

Max(set) - empty cells are ignored

Max Amount
-1.0

Special Examples (errors, null, ...)

Max(NULL), Max({})

Returns an empty cell if applied to an empty set or a NULL entity.

Query

WITH
    MEMBER [Measures].[Max Amount] AS Max( null )
SELECT
    [Measures].[Max Amount] ON 0
FROM
    [Sales]

Result

Max Amount

Max Amount

Assertion : Cell Equals

WITH
    MEMBER [Measures].[Max Amount] AS null
SELECT
    [Measures].[Max Amount] ON 0
FROM
    [Sales]