CurrentMember
When iterating through the hierarchy or set of members, the CurrentMember function dynamically returns the member being operated upon.
It is like saying, "You are here," and the value is calculated for this particular member.
Syntax
Dimension_Expression.CurrentMember Hierarchy_Expression.CurrentMember
Arguments
Dimension_Expression Hierarchy_Expression | MDX expression to return a dimension at the default hierarchy or specified hierarchy for the dimension |
|---|
Examples
Example with default Issue hierarchy
[Issue].CurrentMember address Issue dimension current member from the default hierarchy. In this example, List of issues in progress, the dimension Issue default hierarchy on the level Issue is used on Rows. [Issue].CurrentMember addresses one particular issue for each row.
Example with Issue.Epic hierarchy
Another example report Issue Epic Gantt chart, where the dimension Issue.Epic hierarchy on the Epic level is used on Rows. [Issue.Epic].CurrentMemberaddresses one particular epic for each row in the same report. See also CurrentHierarchyMember to address members of any selected hierarchy.
Example with Descendants
Calculated measures can iterate through dimension members even if the dimension is not selected in report rows, columns, or pages. The function CurrentMember addresses each member from a particular dimension and it tells where the calculation is being executed.
It can be used with set functions where the most popular ones are Childrenset, Descendants, and Members.
The following example would return the issue count of issues created and resolved in the same period (complex filtering criteria).
NonZero(Sum(
Filter(
-- iterate through set of issues
Descendants([Issue].CurrentMember,[Issue].[Issue]),
-- apply filter criteria to each issue
DateInPeriod(
[Measures].[Issue created date],
[Time].CurrentHierarchyMember ) AND
DateInPeriod(
[Measures].[Issue resolution date],
[Time].CurrentHierarchyMember )
),
-- numeric expression - sum of relevant issues
[Measures].[Issues created]
))