Power BI Dashboard Help with DAX

[sudhirkumra]

Hi,

I have got a Table that I have imported in Power BI it's called 'HeatMap Data'. This Table has got columns below:

Portfolio, Programme, Project, C3T ID, Target, Target, Parent Target, Relationship, Source Type

Relationship can be either 'Delivers' or 'Depends'. I want to have a report where user can choose a Value for Portfolio/Programme/Project ( There are Programmes under Portfolios and Projects under Programmes ). Once they chhose this, A table should display all the Target that This Portfolio->Programme->Project is dependant on i.e. where relationship = "Depends". And another Visula by the side that should display all other Portfolio->Programme->Project ( except the chosen value from slicer ) that can Deliver any of those Targets i.e. Relationship="Delivers". Any help would be highly appreciated regarding creating a Data Model and This Report. I am an Azure Data Engineer but have to deliver this. 

Many Thanks in Advance

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...