Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have a two tables
Story Table
Story ID | Story Point |
101 | 5 |
102 | 8 |
103 | 2 |
104 | 13 |
Another one is a mapping of Story & Sprint Table, where one story may belong to more than one sprint
Story Sprints
Story ID | Sprint ID |
101 | 1 |
101 | 2 |
102 | 1 |
102 | 2 |
102 | 3 |
103 | 1 |
103 | 2 |
Now, I want to add a column in this Story Sprint Mapping table called "Story points", that should be derived from "Story points" value of Stories table, and divide by number of sprints it has against the respective story ID in "Story Sprints" table
For e.g. it should show something like this below ->
Story Sprints
Story ID | Sprint ID | Story Points |
101 | 1 | 2.5 |
101 | 2 | 2.5 |
102 | 1 | 2.7 |
102 | 2 | 2.7 |
102 | 3 | 2.7 |
103 | 1 | 1 |
103 | 2 | 1 |
Solved! Go to Solution.
Hi,
I assume the relationship is created like below.
Please check the below picture and the attached pbix file.
Story Points CC =
DIVIDE (
RELATED ( Story[Story Point] ),
COUNTROWS ( FILTER ( Sprint, Sprint[Story ID] = EARLIER ( Sprint[Story ID] ) ) )
)
Hi,
I assume the relationship is created like below.
Please check the below picture and the attached pbix file.
Story Points CC =
DIVIDE (
RELATED ( Story[Story Point] ),
COUNTROWS ( FILTER ( Sprint, Sprint[Story ID] = EARLIER ( Sprint[Story ID] ) ) )
)
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |