Slice with unique rows filtered

[ArturasF]

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:

UserEmail	ManagerEmail
aaad	111
aaa	222
aaa	222
bbb	222
bbb	222

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.

FILTER gives me similar results

[Hussein_Osseily]

---

@ArturasF wrote:

in this case

aaa
bbb

---

Can you give another example ? i didn't get properly why aaad is not there and why you don't want to include it 

[ArturasF]

i only need data rows that belong to manager 222. so it is filtering on manager, and also on top - only unique column's rows.

[Markus_Malessa]

Your slice filter should just be:

USEREMAIL() = [ManagerEmail]

[ArturasF]

That leaves the duplicates. How to get rid of duplicates too? Maybe a virtual column..

[Markus_Malessa]

Maybe try the following instead:

[keycolumn] = MINROW("OfficialApps", "_ROWNUMBER", [UserEmail] = USEREMAIL())