Union - MDX operator reference
Performs a set operation that returns a union of two sets, removing duplicate members.
Syntax
Set_Expression + Set_Expression
Parameters
Set_Expression
A valid Multidimensional Expressions (MDX) expression that returns a set.
Return Value
A set that contains the members of both specified sets.
Remarks
The + (Union) operator is functionally equivalent to the Union (MDX) function.
Examples
The following example demonstrates the use of this operator.
-- This member returns the gross profit margin for each year for North American countries.
SELECT
[Date].[Calendar].[Calendar Year].Members ON 0,
{[Sales Territory].[Sales Territory].[Country].[United States]} +
{[Sales Territory].[Sales Territory].[Country].[Canada]} ON 1
FROM
[Adventure Works]
WHERE
([Measures].[Gross Profit Margin])
See Also
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for