Forum Discussion

maxduff59's avatar
maxduff59
Icon for Helper II rankHelper II
3 years ago

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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
henkvankester's avatar
henkvankester
Icon for Helper I rankHelper I
3 years ago

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])

maxduff59's avatar
maxduff59
Icon for Helper II rankHelper II
3 years ago

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