The MDX Except function returns a subset containing the differences between two sets, optionally retaining duplicates. The two input sets must have identical dimensionality.

Syntax

Except ( set1, set2 [,ALL] )

Arguments

set1

A set to compare with set2.

set2

A set to comparet with set1.

ALL

The optional ALL flag retains duplicates. Matching duplicates in set1 and set2 are eliminated.

Notes

Examples

select
except(members(Goods), children(Goods.[foods])) on 1,
{ ( measure.cost ) } on 0
from [logistics.test]
where
( Goods.[foods].[nut], Transport.[railway], [starting region].[Asia].[China], [starting date].[2019].[Q3].[M7], [completion date].[2019].[Q3].[M7] );

	cost
ALL	123456789
Kitchen & Dining	0
Bento Boxes	0
Food Savers	0
Water Bottles	0
Rice Cookers	0
Home Electronics	0
LCD HDTVs	0
LED HDTVs	0
TV Boxes	0
Video Games	0
Cell Phones & Accessories	0
iPhone	0
Android Phones	0
Headphones & Earphones	0
Cell Phone Parts	0
Computers & Cameras	0
Tablet PCs	0
Software	0
Desktops	0
Laptops & Netbooks	0
foods	123456789
electronic product	0
mobile phone	0
computer	0
smart watch	0
household appliances	0
washing machine	0
refrigerator	0
television	0