topic Re: RLS based on 3 columns (All possible combinations) in DAX Commands and Tips

RLS based on 3 columns (All possible combinations)

AlwaysAGooner — Wed, 31 Jan 2024 16:21:57 GMT

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.

Re: RLS based on 3 columns (All possible combinations)

Anonymous — Thu, 01 Feb 2024 05:30:43 GMT

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

Re: RLS based on 3 columns (All possible combinations)

AlwaysAGooner — Thu, 01 Feb 2024 05:44:32 GMT

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.