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...
As henkvankester mentioned, I am not sure either what you trying to filter, but the second table seems like its finding the average distance for a player, if you create a measure in the first table to find an average distance by the player, I believe would solve your problem.
if not, Userrelationship is way to go.
https://learn.microsoft.com/en-us/dax/userelationship-function-dax
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.