Forum Discussion

danielPrieto's avatar
danielPrieto
Icon for Advocate I rankAdvocate I
8 years ago

Relationships with bridge tables

Hi,   I have a data model like this:       I have a Fact Table (UserEvaluation) and some dimensions (User, Group and Client). The relation between Group and User y m:n so we also have a b...
Need Help
danielPrieto's avatar
danielPrieto
Icon for Advocate I rankAdvocate I
8 years ago

Hi 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:

GroupIDGroupNameClientID
1Group_11
2Group_22
3Group_32
4Group_42

 

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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

You can Edit interactions in Power BI Desktop and make the client and group slicers not filter each other

  • danielPrieto's avatar
    danielPrieto
    Icon for Advocate I rankAdvocate I
    8 years ago

    Hi Anonymous, 

    thanks for your suggestion but this is not a real possibility. Here I am showing a sample of data but in the real data I have many clients and thousands of groups so I need that if I filter by client, only their groups appear.


    Regards,

    Daniel