Forum Discussion

AlwaysAGooner's avatar
AlwaysAGooner
Icon for Helper I rankHelper I
2 years ago

RLS based on 3 columns (All possible combinations)

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.

DAX
Dynamic RLS
RLS

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      AlwaysAGooner
      Icon for Helper I rankHelper I
      2 years ago

      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.