Forum Discussion
Advocate IRelationships with bridge tables
Advocate IHi v-danhe-msft,
When I say "user's results" I mean "user's evaluation" but getting the username from the UserEvaluation table is enough. However, with your approach I would have another similar problem:
If I have a group that has not users that group would not appear in the corresponding filter:
Suppose the same case but now Group table is:
| GroupID | GroupName | ClientID |
| 1 | Group_1 | 1 |
| 2 | Group_2 | 2 |
| 3 | Group_3 | 2 |
| 4 | Group_4 | 2 |
And Gorup_4 has no users:
In this case, If I select Client2, Group_4 dissapear:
I would like to be able to filter a client and see all their groups (with or without users) but if I don't select any group I would like to see all user's evaluation (whether or not they are in a group). You can download de .pbix here.
Is there any possibility to do this?
Regards,
Daniel
Microsoft EmployeeHi danielPrieto,
Based on my test, you could try to modify the relationship between the 'User' table and 'BridgeUserGroup' table:
Result:
Regards,
Daniel He
- danielPrieto
Hi v-danhe-msft
As I said before, this is not a real possibility. In the real case, we have hundreds of clients and thousands of groups so when I filter a client I also need to see ONLY their groups. In your proposal when filtering by Client_2 all the groups appear but Group_1 belongs to Client_1 so it should not be displayed.
In addition, the relationship between User and BridgeUserTable should be in the opposite direction since a user could belong to several groups, that is:
In summary, I need that when filtering a client:
- Your users are filtered.
- Your groups are filtered and, therefore, you can then filter the users of these client by one of their groups.
Regards,
Daniel
- danielPrieto
Any idea for this problem?