Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Total newbie here so please forgive me if this seems really simple.
I am using Jira data loaded into Power BI and I am trying to calculate the total number of story points for issues that are a child of an epic, using this total to give me Epic total Storyt Point invested.
Here is an example of the data I think I need to use I have pretty much every field in Jira loaded and feeding my reports through a dataflow
epic_link | issue_key | story_points | issue_type |
GDES-1234 | GDES-6547 | 1 | story |
GDES-1234 | GDES-78965 | 3 | story |
GDES-987453 | GDES-4123 | 5 | story |
GDES-987453 | GDES-6321 | 8 | task |
GDES-987453 | GDES-57921 | 5 | spike |
GDES-987453 | GDES-167934 | 3 | story |
So for GDES-1234 I would get a total Epic Story Point Velue = 4
and GDES-987453 I would get a total of 21
I am just at a loss on how to move forward.
Solved! Go to Solution.
Measure:
story_points total for epic_link =
IF( HASONEVALUE('Table (2)'[epic_link]),
CALCULATE(
SUM('Table (2)'[story_points]),
filter( allselected('Table (2)'),
'Table (2)'[epic_link] = SELECTEDVALUE('Table (2)'[epic_link])
)
),
SUM('Table (2)'[story_points])
)
You can use all('Table (2)') or allselected('Table (2)') per your needs ...
https://mitchellpearson.com/2020/09/14/understanding-row-context-in-dax-and-power-bi/
Measure:
story_points total for epic_link =
IF( HASONEVALUE('Table (2)'[epic_link]),
CALCULATE(
SUM('Table (2)'[story_points]),
filter( allselected('Table (2)'),
'Table (2)'[epic_link] = SELECTEDVALUE('Table (2)'[epic_link])
)
),
SUM('Table (2)'[story_points])
)
You can use all('Table (2)') or allselected('Table (2)') per your needs ...
https://mitchellpearson.com/2020/09/14/understanding-row-context-in-dax-and-power-bi/
That works great thanks for the quick response.
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |