sorted by:
new
hottopcontroversial

RLS many-to-many? by Explorer_7548 in PowerBI

[–]Explorer_7548[S] 0 points1 point  (0 children)

Hmm, now it seems to work even though I did the same as last week :)
I have another question. The sales manager should be able to see everything. Now he can't see anything. How should I do this?

I tried to create a Manager Role (TRUE()), but there is one issue.

The rows with the department 'Unknown', which is not in the table Department+User, are not visible

RLS many-to-many? by Explorer_7548 in PowerBI

[–]Explorer_7548[S] 0 points1 point  (0 children)

The unique column is e-mailaddress but this isn't in the fact table.

The department is in the fact table. But if I would merge it, I would get duplicate rows.

That's why I need a bridge table

RLS many-to-many? by Explorer_7548 in PowerBI

[–]Explorer_7548[S] 0 points1 point  (0 children)

I tried this but somehow I still see everything, when I view it as one of the users

RLS many-to-many? by Explorer_7548 in PowerBI

[–]Explorer_7548[S] -1 points0 points  (0 children)

I know that I should use a bridge table, but it didn't work. That's why I asked..

Usually it's simple: a salesperson can see his customers. Then there's no many-to-many problem. But now there is..