Document toolboxDocument toolbox

Descendants

Owned by Gvido
Last updated: Aug 03, 2022
1 min read

Returns the set of descendants of a member at a specified level.

Syntax

Descendants( Member_Expression , Level_Expression )

Arguments

Member_ExpressionMDX expression that returns a member.
Level_Expression

MDX expression specifying a member level for the set.

Returns


Set_ExpressionMDX expression that returns set of particular level members

Example

The example below would return the average Gross profit monthly for the selected year

Avg( 
 Descendants(
  [Time].[Year].CurrentMember,
  [Time].[Month]
 ), 
 [Measures].[Gross profit base amount]
)