Average among siblings
Average among siblings, as a calculated measure, is typically used to compare the result of each member in a group where the group is formed from his siblings. In case of a known hierarchy, the core expression is relatively easy.
(
[<Dimension name>].[<Hierarchy name>].CurrentMember.Parent,
[Measures].[<Measure name>]
)
/
Count(
NonEmpty(
[<Dimension name>].[<Hierarchy name>].CurrentMember.Siblings,
[Measures].[<Measure name>]
)
)
<> represent placeholders.
Tags: mdx