Except

Set operations which returns members of set1 but removes any members that are in set2.

Syntax

 Except( Set_Expression_1 , Set_Expression_2 )

Arguments

Set_Expression_1
MDX expression that returns set of members which should be included in the final set.
Set_Expression_2
MDX expression that returns set of members which should be excluded from the first set in the final set.

Examples

Following formula will aggregate all US states in Customer dimension without west coast states (CA, OR, WA).

Aggregate(
  Except(
    [Customers].[USA].Members,
    { [Customers].[USA].[CA],
      [Customers].[USA].[OR],
      [Customers].[USA].[WA] }
  )
)

See also