Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

PowerBi report for interdependent row

Hi All, Which option should i use when the data is in the below structure. Work item "Test case" is the parent and the "Bug" is the child links. One test case work item might have multiple child link...
Dataflow
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous

     

    Create an index column in Power Query editor and create columns like below:

    group = CALCULATE(MAX('Table'[Index]),FILTER('Table','Table'[State]="completed"&&'Table'[Index]<=EARLIER('Table'[Index])))

mark = IF('Table'[State] in {"completed","removed","Done"},1,0)

_min = CALCULATE(MIN('Table'[mark]),ALLEXCEPT('Table','Table'[group]))

     

    At last, create a measure like below:

    Measure = IF(SELECTEDVALUE('Table'[Index])=SELECTEDVALUE('Table'[group])&&SELECTEDVALUE('Table'[_min])=1,1,BLANK())

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous

 

Create an index column in Power Query editor and create columns like below:

group = CALCULATE(MAX('Table'[Index]),FILTER('Table','Table'[State]="completed"&&'Table'[Index]<=EARLIER('Table'[Index])))

mark = IF('Table'[State] in {"completed","removed","Done"},1,0)

_min = CALCULATE(MIN('Table'[mark]),ALLEXCEPT('Table','Table'[group]))

 

At last, create a measure like below:

Measure = IF(SELECTEDVALUE('Table'[Index])=SELECTEDVALUE('Table'[group])&&SELECTEDVALUE('Table'[_min])=1,1,BLANK())

 

Best Regards,

Jay