Double Filtering (by the same thing)

[ebuttazzi]

So i have a competitive League of Legends scheme, and i want to do some stuff that i cant find googling:

In league, each team (or Side) has 5 champions, and i want to filter the sides not by one champion, but by 2 or 3 champions.

If i simply select, thing will show me their averages or their sums.

I tried in filter to use advanced filter "Ezreal" and "Azir", w/o sucess.

My relationships:

Game has many sides, Sides has many Champions.

image of relationship:

Do I have to create any cross relation? 

[Salonic]

Hi,

You will have to create new measures / tables.

Could you share your data and the result you want in order to understand what you need ?