Members

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

Syntax

Hierarchy_Expression.Members

or

Level_Expression.Members

Arguments

Hierarchy_Expression

Level_Expression

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 last six month

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

See also

• Function Filter
• Function Rank
• Function Order