EXCEPT
Description:
The function is used to evaluate two sets and removes those tuples in the first set that also exist in the second set, optionally retaining duplicates.
Syntax:
Except(Set_Expression1, Set_Expression2 [, ALL ] )
Return Type:
SET
Parameters:
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 Order Quanlity] ON COLUMNS,
Except
(
{[Customer].[Geography].[Country]},
{[Customer].[Geography].[Country].&[Australia],
[Customer].[Geography].[Country].&[Canada]}
) ON ROWS
FROM
[AdventureWorksMF]