topic Re: DAX expression issue for Dynamic Row level Security in DAX Commands and Tips

DAX expression issue for Dynamic Row level Security

dbollini — Mon, 21 Mar 2022 17:50:47 GMT

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

Re: DAX expression issue for Dynamic Row level Security

amitchandak — Wed, 16 Mar 2022 17:19:32 GMT

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

Re: DAX expression issue for Dynamic Row level Security

dbollini — Wed, 16 Mar 2022 20:03:58 GMT

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

Re: DAX expression issue for Dynamic Row level Security

amitchandak — Thu, 17 Mar 2022 02:36:42 GMT

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))

Re: DAX expression issue for Dynamic Row level Security

dbollini — Thu, 17 Mar 2022 21:29:21 GMT

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

Re: DAX expression issue for Dynamic Row level Security

dbollini — Fri, 18 Mar 2022 20:56:05 GMT

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.