Forum Discussion
Filtering two tables without relationship but with same values
Hi everybody, I would like to know if it was possible to find a way to use one filter for two tables even if they are not related. Indeed, in my model, I cannot add relationship because it would c...
I don't know what you want to filter, but maybe you should create an inactive relationship between these tables.
Next, you should make a measure like:
CALCULATE( ..... , USERELATIONSHIP('nametable1'[joueurs], 'nametable2'[joueurs])
For exemple, here I would like one slicer which allows me to select one player.
For exemple, if I select "Joueur1" in my slicer I would like to have the table values of this player only for the table "Trainings" and the table "Games" even if they do not have a relationship