Forum Discussion
How to get one table to automatically filter another
I am trying to build a report where when users log in, their email filters their view automatically so their only see their or their staff's data. I used PRINCIPALUSERNAME( ) as a measure to auto...
amitchandak I started with using dynamic RLS but when that did not work I looked into alternative routes to get the desired results. RLS roles are not filtering the data based on user (my user name sees everything and when I view as another user the filter does not affect the table).
The closest I can get is using IF(SELECTEDVALUE(Staff_Member[Staff_eMail_Address])=USERPRINCIPALNAME(),1,0) as a filter for the intermeding table but I cannot get the second table to filter the overall client count table.