I have a Power BI table called "CoppeCitta" with several columns, you can see below a sample:

enter image description here

Then, I have all the visuals in the below page:

enter image description here

You can see the three slicers: "Competizione" on the left (filtering the same column "Competizione"), "Scegli anno" in the middle (filtering the year in the column "Anno") and the cities on the right. This last slicer is actually filtering another linked table, but it gives the same value as the column "CittaMain".

If you look at the table in the centre bottom, what I want to achieve is that instead of showing all the records, it gets filtered on the "SFPair" which corresponds to the combination of the three slicers above.

I have tried several combinations of measures, but I always fail to get the filtering working properly (the SFPair never gets filtered).

Table "CoppeCitta" extract: | CittaMain | SFPair | SFPoints | Competizione | Anno | | --------- | ------ | -------- | ------------- | ---- | | 149 | 0 | 0 | Coppa di Lega | 2023 | | 153 | 0 | 0 | Coppa di Lega | 2024 | | 156 | 0 | 0 | Coppa di Lega | 2023 | | 158 | 0 | 0 | Coppa di Lega | 2023 | | 160 | 0 | 0 | Coppa di Lega | 2023 | | 161 | 0 | 0 | Coppa di Lega | 2023 | | 164 | 0 | 0 | Coppa di Lega | 2023 | | 167 | 0 | 0 | Coppa di Lega | 2023 | | 168 | 0 | 0 | Coppa di Lega | 2023 | | 169 | 1 | 4 | Coppa di Lega | 2023 | | 190 | 0 | 0 | Coppa di Lega | 2024 | | 194 | 1 | 0 | Coppa di Lega | 2024 | | 203 | 2 | 0 | Coppa di Lega | 2024 | | 208 | 0 | 0 | Coppa di Lega | 2024 | | 213 | 0 | 0 | Coppa di Lega | 2024 | | 237 | 2 | 4 | Coppa di Lega | 2024 | | 378 | 0 | 0 | Coppa di Lega | 2024 | | 384 | 0 | 0 | Coppa di Lega | 2023 | | 386 | 0 | 0 | Coppa di Lega | 2023 | | 398 | 0 | 0 | Coppa di Lega | 2023 | | 400 | 2 | 4 | Coppa di Lega | 2023 | | 404 | 0 | 0 | Coppa di Lega | 2023 |

Edit: expectation of the output. Looking at the below visual table, it is currently displaying four record. I want that, for example, if I filter in a slicer "Parramatta" (which is a record in "CittaMain column") that table is filtered on the two records with SFPair=2. Or for example, if I filter on "Lae", the table is filtered showing the two records with SFPair=1