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(
[Item].[Item].Members,
{
[Item].[AUDIO - Audio Products].[10106 - CD player],
[Item].[AUDIO - Audio Products].[10107 - CD's - High density],
[Item].[AUDIO - Audio Products].[10109 - CD rack]
}
)
)
See also
- Function Aggregate