Hello all. I’ve succesfully created a report which filters data & visuals by the current user and the department she or he works for. That all works great.
But, I wish to expand the dax-query: a user should not only see data concerning her or his department, but also the data of the entire organisation. But not the data of other departments!
I’m wondering how I can achieve this.
I’ve included a snippet with the formula I now use for the RLS-setup:
It’s partially Dutch, so:
“Medewerker” = employee
“Org_eenheid_naam” = department
“werk_email” = email address
Thanks in advance for any feedback.