Forum Discussion

wasonj1's avatar
wasonj1
Frequent Visitor
5 years ago

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...
Need Help
lbendlin's avatar
lbendlin
Super User
5 years ago

You cannot have a department field in the user table. But you need a department field in the Incidents table.  No idea how you get that when your users can be assigned to multiple departments.

wasonj1's avatar
wasonj1
Frequent Visitor
5 years ago

Why can't there be a department field in the user table?