Interview Preparation mode beta
Funny Facebook Status Funny Facebook Status
Enter your email address

How can I define SCOPE in MDX for all but one measures in one measure group?

Nice?Vote!

1 Answer

Nice?Vote!
You can use function MeasureGroupMeasures() and subtract set of measures that should be excluded.

Example:

SCOPE(MeasureGroupMeasures("Internet Sales") - {[Measures].[Internet Tax Amount]});
This = ...;
END SCOPE;
answered 1 year ago by R (19,530 points)

Related questions