Forum Discussion
Filtering data from multiple tables based on logged in user
Hello, I am working on my second PowerBi dashboard. It has three tables, Incidents, User, and Users Departments (some users are assigned to multiple departments). Currently I have it setup to filter...
Quote: "(some users are assigned to multiple departments)"
Dimension tables need to have unique key columns.
Thanks for the response, that makes sense. On the user table we only have the primary department they are associated with so it is unique there. On the Users Department table we have a record for each department they are in.