DAX expression issue for Dynamic Row level Security

[dbollini]

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 have access to based on the employee id or employee no in the Viewcorezcodereport and display only those protocol information in teh power Bi report.

How do i solve the complicated Dax expression required

[amitchandak]

@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

[dbollini]

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

[amitchandak · Accepted solution]

@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]

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.

[dbollini]

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