Max (MDX)
Returns the maximum value of a numeric expression that is evaluated over a set.
Składnia
Max( Set_Expression [ , Numeric_Expression ] )
Arguments
Set_Expression
A valid Multidimensional Expressions (MDX) expression that returns a set.Numeric_Expression
A valid numeric expression that is typically a Multidimensional Expressions (MDX) expression of cell coordinates that return a number.
Uwagi
If a numeric expression is specified, the specified numeric expression is evaluated across the set and then returns the maximum value from that evaluation. If a numeric expression is not specified, the specified set is evaluated in the current context of the members of the set and then returns the maximum value from that evaluation.
[!UWAGA]
Analysis Services ignores nulls when calculating the maximum value in a set of numbers.
Example
The following example returns the maximum monthly sales for each quarter, subcategory, and country in the Adventure Works cube.
WITH MEMBER Measures.x AS Max
([Date].[Calendar].CurrentMember.Children
, [Measures].[Reseller Order Quantity]
)
SELECT Measures.x ON 0
,NON EMPTY [Date].[Calendar].[Calendar Quarter]*
[Product].[Product Categories].[Subcategory].members *
[Geography].[Geography].[Country].Members
ON 1
FROM [Adventure Works]