Forum Discussion
DAX expression issue for Dynamic Row level Security
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 , 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
Thank you but it ddid not work as based on there login i have to get there employeeid or employeeno then get the records matching from the Viewcorezcodereport table
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))
Thank you i am getting the ID with the first measure but second measure does not like the last one in_tab to use it as it says error and how am i supposed to use the measures to filter the data in the power Bi report
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.