Wrong Filter Flow Direction when using Excel Power Pivot

Hello everyone!

I am having a problem which is doing my head in.

So in the file attached, you can see that I have a table for Package, a table for Arenas (Products), and a table of which arenas belong to which Packages. An Arena can belong to 1 or many Packages and a Package can include 1 or many Arenas, therefore I created a table between them where you simply add this information.

Now, I want to see which arenas belong to which Packages but the filter direction goes in the "wrong way". I want to be able to filter the Package table and see which arenas that belong to that package but as you can see, I get that all arenas are included in all packages (because of the filter direction).

If this was Power BI, I would change the direction of the relationship to "both" but this does not seem to be a function in Excel Power Pivot.

I need help 🙂

Kind Regards,

Kind Regards,

Robin