Split Column Value in another table

[yogeshk77]

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

[Jihwan_Kim · Accepted 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] ) ) )
)