Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Union distinct column values based on selection in another table

Hi everyone. I have a table of users (and various selection criteria columns) and their relationships. I would like help with getting Power BI to generate a table of distinct users, based on selectio...
  • mauriciosotero's avatar
    6 years ago

    To achieve yours needs, you can add in the Relationship table rows with a combination between the users with themselves, like this:

     

     

    And I suggest to delete the inactive relationship between the two tables.