MDX expression to return a dimension at the default hierarchy
or specified hierarchy for the dimension
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).