If the user has drilled down to the Assignee level, this measure determines whether it is in scope. If it is, it returns the number of tasks assigned to that assignee. In order to prevent displaying redundant information, it returns BLANK() if the user is at a higher level (such as Sprint or Project).
Dynamic Assignee Data Display:
Include this measure in the matrix visual's Values field.
Based on the logic of the measure, the matrix will automatically adapt and show the assignees for the pertinent project or sprint level when users drill down.
Turn on Drill Down:
Make sure your matrix visual has the drill-down feature activated. To drill down to the next level of the hierarchy, users can click the + button (for example, from Project to Sprint, then from Sprint to Assignee).Hierarchical drill-downs combined with dynamic measures or calculated columns can be used to dynamically display assignees based on hierarchy drill levels in a Power BI matrix (for example, using Jira data). This allows you to display different levels of assignee data according to the user's interaction with the matrix.
Here's how to do it:
Steps: Verify the Data Model's Hierarchy Structure:
To enable drill-downs, your data model should have a hierarchy (Project > Sprint > Assignee, for example).
The information pertaining to these entities (e.g., Jira tasks, status, assignee, etc.) should be included in the fact table, along with a dimension table for the hierarchy (such as Project, Sprint, and Assignee).
Make a Visual Matrix:
Incorporate a matrix graphic into your report.
Drag the fields in the hierarchy (such as Project, Sprint, and Assignee) into the Rows field well. The assignee field will be the lowest level of the hierarchy.
This will allow users to drill down from the Project level to the Sprint level and finally to the Assignee level.
Use a Measure to Dynamically Display Assignees:
-
To dynamically display data based on the hierarchy level, create a measure that changes based on the level of drill-down.
-
For example, if you want to count the number of tasks assigned to each person, use this measure:
AssigneeCount =
VAR CurrentLevel =
ISINSCOPE('Hierarchy'[Assignee])
RETURN
IF(
CurrentLevel,
COUNTROWS('JiraTasks'),
BLANK()
)
