RLS based on 3 columns (All possible combinations)

[AlwaysAGooner]

Hi All,

Looking to implement RLS that is based on 3 columns. So all possible combinations must be taken in to account while filtering.

Consider the below table, the user could fall in either:

- None of the columns, OR
- Any 1 column, OR
- Any 2 columns, OR
- All 3 columns

I am using an excel to capture the role against email IDs but can't crack the DAX yet in Manage Roles, any leads with the DAX will be really helpful.

[Anonymous]

HI @AlwaysAGooner,

I'd like to suggest you create a new table to unpivot these conditional fields and link the user table. Then you can use the new table as bridge to link user table and other tables and apply security filter effects.

Unpivot columns - Power Query | Microsoft Learn

Regards,

Xiaoxin Sheng

[AlwaysAGooner]

Thanks for your response @Anonymous.
I need the DAX code that could accomodate all possible permutations. I am able to filter but yet to put togther a code that can accomodate all combinations under one RLS role.