Implement row level security where one group sees part of data and everyone else sees the other part

[jfbonterra]

Hello! Apologies for the oddly-phrased subject. I'm attempting to set RLS so that one defined group of people sees a subset of data and everyone else sees the other subset of data. 

I have a table with a column titled Team/AOP that has two values; Team and AOP.

I have a list of people that should see only rows that have the value of AOP. Everyone else should see the data that has rows with the value of Team. 

The part that's tripping me up is I don't have a set list/way to define users who should see Team data. There's nothing in my dataset that indicates what they should see, it's just all users who aren't in the AOP group. 

I've spent some time looking at dynamic RLS but it doesn't quite seem to solve what I need. This seems like it should be relatively easy, and I may be missing something obvious.

This is the only table I need to include in the filter logic:

Here's a simplified view of the table.

Is anyone able to point me in the right direction for this solution?

Thanks!

[luisrh]

You need to be able to have a filter dimension bridge table.   In other words,  you can have a table with the names of the users that can see AOP.    Then your DAX filter can interrogate the incoming (UserName) and then apply the filter on this table.   Of course in order for visuals to work, you must have the relationships in place.  Without more information related to your model and DAX filter that is the only conclusion I can make.