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: ...
DAX
Dynamic RLS
RLS
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.