Only allow User to see data of other users that have the department as him/her

[SignXi2]

Hi Everyone,

I have a small bug on one of my expression. basically here is what I'm trying to achieve :

I create a slice from a table and I want the signin user to only see the informations of the other users that have the same department name as him in the department column. all the usermail a sored in a column in the table called workemail .Here is the expression I wrote:

[department]=SELECT([department], [workemail] = USEREMAIL())

Hope someone can help.

Thanks in advance.