I have two tables, one contains each country and its revenues, the other contains the managers and their countries as below:
In the manager field there is the Email of each manager.
Anyone can advise how can I apply the Row level security in such case?
Below is how the table looks like
use the USERNAME() function in the Row Level Security settings. Mange roles -> create a new role -> select a table with usernames -> Table filter DAX expression , Manager = USERNAME()
sure, it won't work while testing, because having a role defined like: [Email] = USERNAME() it will check the actual logged user. Try to manipulate your dataset, add a test email adress as a manager (to which you have access to), publish the report to the Power BI Online Service, and then log in with that test user ;-)
I'd like to suggest you modify the 'cross filter direction' option to 'both' and active the 'Apply security filter in both directions' option.