RLS as an exception

[Anonymous]

How would you build a role level security where they have access to everything EXCEPT something?  I want everyone to be able to see all expense categories for all cost centers EXCEPT salaries and wages, and then only see salaries and wages for certain cost centers (from a table list of these cost centers).

I found where you could filter on 1 field (cost center) based on a table of e-mails and built that.  -> CONTAINS(Permissions, Permissions[Cost Center],'CC List - 2019'[Cost Center],Permissions[Email],[Getemail]) 

This would work if I just wanted to give people access to certain cost centers, but I only want to filter those cost centers on 1 field.

[v-danhe-msft]

Hi @Anonymous ,

Could you have tried to define any rules for your data?

https://docs.microsoft.com/en-us/power-bi/service-admin-rls#define-roles-and-rules-in-power-bi-desktop

If you could share a simple data and post your desired result will be better.

Regards,

Daniel He