RLS/Dynamic Filter Help needed

You don't need to have Table1 linked to Table2.  Table1 is there just to get the employee and what region they can see.  You use that information to filter Table2.

Create a role with a filter on Table2 like this.

VAR _UPN = USERPRINCIPALNAME()
RETURN Table2[LOCATION] = LOOKUPVALUE(Table1[LOCATION],Table1[EMAIL],_UPN)

USERPRINCIPALNAME() gets the account of the person that is logged in.  The model uses that to get the region that user can see and apply the filter to Table2.

I have attached my sample file for you to look at.

jdbuchanan71 
It appears that the LOOKUP isnt working 😞
when I add the SA[location] to a table on a seperate page and apply the modelling the column filtering of the data does not change

I'm not sure what you are saying.  There is a 3rd table involved and you are trying to filter that one as well?

Please share sample data from each table with the real table names rather than "table1 and table2" and descibe the filtering you are trying to apply to each table.

jdbuchanan71 
Sorry will try to better explain my objective

When a user 'Peter Green' logs in I would like him to only see from SA table
Anyone who is at the same [location] and  [job_watch] (can i add data from either table as additional columns? I havent added all the columns on here)

Sorry I have a much clearer head today!

Expected outcome

When a user 'Andy Jones' logs in I would like him to only see from SA table

SA Table

WMFSED table

jdbuchanan71 
Apparently my post need moderator approval 😞

If you are trying to apply filters to multiple tables you would have to write rule for each one in your Role.  If there was a Table3 in the example below and you wanted to apply a filter to it as well you would have to select table3 and put the DAX filter code in.  You can't filter Table3 with code that is applied to Table2.

Gotcha, that makes more sense.  I am going to assume you don't want users to see anything from the 'WMFSED Table', this is the table that holds their email and location / job_watch so there is nothing for them to look at anyway.

We apply a filter to the 'SA Table' like this.

VAR _UPN = USERPRINCIPALNAME()
VAR _Location = LOOKUPVALUE ( 'WMFSED Table'[JOB_LOCATION],'WMFSED Table'[WORK_EMAIL],_UPN)
VAR _JobWatch = LOOKUPVALUE ( 'WMFSED Table'[JOB_WATCH],'WMFSED Table'[WORK_EMAIL],_UPN)
RETURN
'SA Table'[location] = _Location &&
'SA Table'[job_watch] = _JobWatch

This reads the 'WMFSED Table'[JOB_LOCATION] and 'WMFSED Table'[JOB_WATCH] based on who is logged in and applies those as filters to teh 'SA Table'

We also apply a filter to the 'WMFSED Table' like this.

FALSE()

This just means that the role cannot see any data on this table.

Using the View as Andy.Jones we can see the filtering applied:

And this is what Pete.Green looks like:

I have attached my updated file for you to look at.