Forum Discussion

dbollini's avatar
dbollini
Helper II
4 years ago
Solved

DAX expression issue for Dynamic Row level Security

      I am trying to solve the issue for complicated DRLS for multiple tables . When user logs in i have to get employee id based on there login adid and use that to search for the protocols they...
  • amitchandak's avatar
    amitchandak
    4 years ago

    dbollini , You can create measures like

     

    measure =

    var _tab = summarize(filter(allselected(ADUser), [email] =userprincipalname()) , ADuser[EmployeeID])

    return

    calculate(countrows(Viewcorezcodereport), filter(Viewcorezcodereport , Viewcorezcodereport [EmployeeID] in _tab))

amitchandak's avatar
amitchandak
Super User
4 years ago

dbollini , if you create a role using you ad user tbale with filter

 

[email] = userprincipalname()

 

Then it should filter both tables for that . Make sure you check flag security filter in both directions

 

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk