Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dax Expression for Dynamic Row level security

Hi I have the following model below which is linked via the Level 4 ID(highlighted in red). In order to avoid a many to many relationship i have created a bridge table(ruf contract bridge). i have al...
Need Help
Show and Tell
Tips and Tricks
  • d_gosbell's avatar
    d_gosbell
    4 years ago
    Anonymous wrote:

    Hi thanks for your response, Yes i understand that would be the easy fix and would work however was wondering about the other way to do it via DAX in which can filter these tables. 

    So if you want the harder to implement solution with worse performance you could probably do something like the following on the 'RUF Contract Bridge' table. 

     

    'RUF Contract Bridge'[Level 4] in CALCULATETABLE( VALUES('Corporate RLS Access'[Level 4]), 'Corporate RLS Access'[Email] = USERPRINCIPALNAME() )

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi thanks for your response, Yes i understand that would be the easy fix and would work however was wondering about the other way to do it via DAX in which can filter these tables. 

  • d_gosbell's avatar
    d_gosbell
    Super User
    4 years ago
    Anonymous wrote:

    Hi thanks for your response, Yes i understand that would be the easy fix and would work however was wondering about the other way to do it via DAX in which can filter these tables. 

    So if you want the harder to implement solution with worse performance you could probably do something like the following on the 'RUF Contract Bridge' table. 

     

    'RUF Contract Bridge'[Level 4] in CALCULATETABLE( VALUES('Corporate RLS Access'[Level 4]), 'Corporate RLS Access'[Email] = USERPRINCIPALNAME() )

    • skidave74's avatar
      skidave74
      New Member
      1 year ago

      This is exactly what I needed, thanks.