Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

undefined

I have a table with data about Jira issues. When I select a row in the table I want to visualize the child items of the selected issue, just to show you what I mean I want something like this:  ...
Need Help
v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

 

I create the sample data.

 

      

 

Please check if this matches your desired output.

 

Accountable and Reporter = 
IF (
    ISINSCOPE ( Ticket[Ticket ID] ),
    SELECTEDVALUE ( Ticket[Reporter] ),
    IF ( ISINSCOPE ( 'Table'[Name] ), MAX ( 'Table'[Accountable] ) )
)
Prio and Title = 
IF (
    ISINSCOPE ( Ticket[Ticket ID] ),
    SELECTEDVALUE ( Ticket[Title] ),
    IF ( ISINSCOPE ( 'Table'[Name] ), SUM ( 'Table'[Prio] ) )
)


If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.