Members

Returns the set of members from a specified dimension hierarchy or level.

Syntax

Hierarchy_Expression.Members

or

Level_Expression.Members

Arguments

Hierarchy_Expression	MDX expression specifies the dimension and its hierarchy.
Level_Expression	MDX expression specifies the dimension and level of members.

Examples

Count projects with more than 100 issues created

[Project].[Project].Members returns all projects from the default hierarchy of the Project dimension. This is used to iterate through all projects — for example, to count only those with more than 100 issues created:

Count(
  Filter(
    [Project].[Project].Members,
    [Measures].[Issues created] > 100
  )
)

Rank months by the number of issues created

[Time].[Month].Members returns all members from the Month level of the Time dimension. Ranks each month (e.g., January, February, etc.) based on the number of issues created.

Rank(
  [Time].CurrentMember,
  Order(
    [Time].[Month].Members,
    [Measures].[Issues created],
    BDESC
  )
)

Bugs created in the Sprints started in the last six months

Returns the total number of bugs created in sprints that started within the past 6 months

Sum(
  Filter(
    [Sprint].[Sprint].Members,
    DateBetween(
      [Sprint].CurrentMember.Get('Start date'),
      '6 months ago',
      'today'
    )
  ),
  (
    [Measures].[Issues created],
    [Issue Type].[Bug]
  )
)