Forum Discussion
Multiple relationships between 2 tables
Thank you very much, it is on good track, but if i use it in table in visual i still get only documents shown for user where user is in first name column. In my model, here are shown 4 documents for the user and he has deliverd 7 documents(in 3 other documents he is in second column-second name). how can i show all 7 when i use filter "Users"
Hi,
To display and filter records like that, i think you need to change the approach to use a bridge table. That will also make your dax measures more simple as you dont need to use "if" & "userelationship".
In your power query, create a new table from the User1, User2, User3 and Doc columns only then unpivot so you only have the two columns of Doc and User remaining.
In the data model, set the relationships so they are active and the DocHeader relationship is Bi-directional.