INTERSECT

Description:

This function is used to return the intersection of two input sets, optionally retaining duplicates.

Syntax:

Intersect(Set_Expression1 , Set_Expression2 [ , ALL ] )

Return Type:

SET

Parameters:

Parameter	Description

Parameter	Description
Set_Expression1	It is a valid MDX expression that returns a set.
Set_Expression2	It is a valid MDX expression that returns a set.

Example:

SELECT
[Measures].[Internet Sales Amount] on 0,
INTERSECT
  (
  {[Customer].[Geography].[Country].&[Australia],
  [Customer].[Geography].[Country].&[Canada]},
[Customer].[Geography].[Country].allmembers
  )
ON 1
FROM [AdventureWorksMF]