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