Is it possible to include multiple measu
Is it possible to include multiple measure groups and then exclude measures from one of the groups?
Example is something like:
Include measure groups "Internet Sales", "Store Sales", "Complaints"
Exclude Internet Tax Amount measure from the "Internet Sales" group
I've tried a lot of things. This doesn't work:
Scope(MeasureGroupMeasures("Store Sales") +
MeasureGroupMeasures("Complaints") +
MeasureGroupMeasures("Internet Sales") -
{[Measures].[Internet Tax Amount]});