Forum Discussion
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...
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))
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))
It is getting the employeeid and i added in the ADusers (manage roles area) but when i tried the second expression last line in _tab)) or Var_tab it is throwing error in the other table manage roles area.