filter on table2 depending on table1 filter

[Gerard76]

Hi,

Here is the situation...

I've got 3 tables:

• First one with existing teams and associated template (each team has a unique template)
• Second one with existing templates and teams having the template associated (I know it looks the same :))
• Third one listing all the parameters of each template

Multiple teams can have the same template associated, but a team can have only 1 template.

I'd like to be able to make a search on a team
==> 1st table shows the template associated to the team searched (1st filter based on the team)
======> 2nd table shows all the teams having this template associated (the template indictaed in the 1st table after this table has been filtered on the team name). I need this 2nd table to kow which teams would be impacted if I modify the template
======> 3rd table would be filtered with the template appearing on the 1st table.

In case a drawing would explain better...

Here's what I've got at the begining:

Here's what I want after I made a search on Team A:

Thanks in advance for your help!

[Gerard76 · Accepted solution]

I've found a solution which is very easy 🙂

https://docs.microsoft.com/fr-fr/power-bi/transform-model/desktop-bidirectional-filtering