Forum Discussion
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 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
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))
5 Replies
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))
