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
