I have measure which holds dedicated value for each item in hierarchy level. Can you help me how can I design this measure to avoid aggregations for each item across all children items?
I tried to do something like this, but I did something incorrectly, because Generate function in this case returns too many items.
SCOPE
(
[Measures].[Test]
,[Organization Structure].[Parent Id].MEMBERS
);
This =
[Measures].[Core Totals Target]
-
Sum
(
Generate
(
(EXISTING
[Organization Structure].[Parent Id].MEMBERS)
,Descendants
(
[Organization Structure].[Parent Id].CurrentMember
,1
,SELF
)
)
,[Measures].[Core Totals Target]
);
END SCOPE;
Do you have an idea how to solve this issue?
Not too sure of the purpose of Generate within your script. It looks like it is doing the same as this: