Filter over multiple tables

[Anonymous]

Hi!

I have two tables that are linked through a periodID. I have filters on one table but they don't apply on the other table. How do I make one selection filter for both tables?

I have one table unique on user per time perspective per period:

 

On that table I apply my filters (on periodtype and period)

Then my related table is per time perspective per period: 

[Eric_Zhang]

---

@Anonymous wrote:

Hi!

I have two tables that are linked through a periodID. I have filters on one table but they don't apply on the other table. How do I make one selection filter for both tables?

I have one table unique on user per time perspective per period:

 

On that table I apply my filters (on periodtype and period)

Then my related table is per time perspective per period: 

---

@Anonymous

Could you share the pbix file? As @Greg_Deckler suggested, you need to check the relationship between those two tables.

[Greg_Deckler · Accepted solution]

In your data model relationship view, make sure that your filter direction is going the right way. In this case, I'd probably make sure that it is going in both directions.