Intersect
Returns the intersection of two sets. By default, duplicates are removed from both sets before intersecting; however, you can optionally specify to retain duplicates.
Syntax
Intersect(Set_Expression1 , Set_Expression2 [ , ALL ] )
Input parameters
Set_Expression1
An MDX expression that returns a set. This must have the same dimensionality as Set_Expression2. It must also consist of tuple sets from the same hierarchy as Set_Expression2.
Set_Expression2
An MDX expression that returns a set. This must have the same dimensionality as Set_Expression1. It must also consist of tuple sets from the same hierarchy as Set_Expression1.
ALL
If specified, Intersect intersects each duplicate in the first set that has a matching duplicate in the second set, in addition to the usual nonduplicated elements.
Example
Intersect( [DateCustom].[StandardMonth].[Month].Members, [DateCustom].[StandardMonth].CurrentMember.Siblings )