I have a simple report that I want to set RLS based on each Manager’s location. I also wish senior managers to be able to see the entire data. If I set up each Manager with his/her appropriate role, will Senior Managers see the entire report, or do I have to set up a senior role to assign to Senior Managers?
You can rely on the Active directory to do so. We have many great discussion on the forum. Please have a look to below link.
Also a video from Darren which shows how to do it using DAX Studio.
And another one which i used recently.