union-mdx-operator-reference.md

title	+ (Union) (MDX)
description	Union - MDX operator reference
ms.date	02/17/2022
ms.service	sql
ms.subservice	analysis-services
ms.topic	reference
ms.custom	mdx

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

MDX Operator Reference (MDX)