Forum Discussion
RLS/Dynamic Filter Help needed
You don't have the two table connected together do you? There is no need for a relationship between the two tables. That is the only thing I can think of that might cause the problem.
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.
jdbuchanan71
There is only 2 tables
the part about adding other columns means from either of the 2 tables in the expression.
Dont know if you got to see this postPOST
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]Sorry I have a much clearer head today!
Expected outcomefull_name email_address location job_watch role_basic assessment Mike New [email protected] B green FF 78 Pete Green [email protected] B green FF 76
When a user 'Andy Jones' logs in I would like him to only see from SA tablefull_name email_address location job_watch role_basic assessment Andy Jones [email protected] A red Crew 90 Mike White [email protected] A red FF 69
SA Tablefull_name email_address location job_watch role_basic assessment Andy Jones [email protected] A red Crew 90 Paul Smith [email protected] B white Watch 79 Dave Brown [email protected] C white Crew 89 Rich Davis [email protected] D blue Crew 76 Steve Blue [email protected] D blue FF 80 Mike New [email protected] B green FF 78 Pete Green [email protected] B green FF 76 Mike White [email protected] A red FF 69 Peter Long [email protected] B blue FF 69 Mitchell Bow [email protected] B red FF 69 WMFSED table
NAME WORK_EMAIL JOB_LOCATION JOB_WATCH Role_Basic Andy Jones [email protected] A red Crew Paul Smith [email protected] B white Watch Dave Brown [email protected] C white Crew Rich Davis [email protected] D blue Crew Steve Blue [email protected] D blue FF Mike New [email protected] B green FF Pete Green [email protected] B green FF Mike White [email protected] A red FF Peter Long [email protected] B blue FF Mitchell Bow [email protected] B red FF
