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]
)