Dyanamic RLS with Groups

[ptmuldoon]

I am trying to learn and set up user permissions using dynamic RLS, yet can't seem to to get it working correctly.  I've treid following the various samples (and videos) from google searches, but still stuck.

 I'm currently working with 5 tables.

1.  UsersTable, this contains a the email (UPN) and a 'SiteGroup'.

2. A "SiteGroups" Table.  This is just a list of all the groups available.

3. A  "SiteLists" Table.  This lists all of the SiteTags associated with each group.

4. A "Dim Sites" Table that is a list of all SiteTags available.

5. A data table

Below is the general model showing the relationships.  

I have setup a role called Permissions with the DAX of [email] = USERPRINCIPALNAME()

I can create a card and see the correct UPN of myself, and have changed the 'ViewAs" to another email address and see that card change as well.

But the data never filters down to only what the user should be able to see for their "SiteGroup"

I thinking/guessing this has maybe something to do with the data model and relationships?

[ptmuldoon]

Sweet!!.   That did the trick!!

[jdbuchanan71 · Accepted solution]

In a default join (1:*) the filter only flows from the 1 to the many.  You would have to make these two relationships bi-directional in order for your user table to filter the data table.