Forum Discussion

yogeshk77's avatar
yogeshk77
Helper I
3 years ago
Solved

Split Column Value in another table

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 th...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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] ) ) )
)

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

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] ) ) )
)