Slice with unique rows filtered

Hello, i am new to this, but have experienve with powerapps and google sheets. I have a dataset and to simplify it looks like this:

UserEmailManagerEmail
aaad111
aaa222
aaa222
bbb222
bbb222

I need to filter the slice so it only shows distinct UserEmails belonging to 222

in this case

aaa
bbb

I find this easier in SQL than in appsheets.

ArturasF_0-1710760249396.png

FILTER gives me similar results

1 5 62
5 REPLIES 5
Top Labels in this Space