Dynamic RLS, controlled from SharePoint list, with ALL option

Hi Anonymous 

I think now your sharepoint list may be like my sample as below.

Due to you need to relate Role ID with Team ID for dynamic RLS .

Blank in Role ID will return to blank, so it is incorret.

If you only want to add master under your exist users in Sharepoint List.

You can try to update your Sharepoint List as below.

View as "[email protected]",   I can only see Team A.

View as "[email protected]", I can see all Teams.

My Dax is same as yours, it works well.

Or  you can try to build Dynamic Row Level Security with Organizational Hierarchy in Power BI.

You can refer to this blog for more details : Dynamic Row Level Security with Organizational Hierarchy.

Video: Row Level Security Organizational Hierarchy

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.