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
@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
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.
Your slice filter should just be:
USEREMAIL() = [ManagerEmail]
That leaves the duplicates. How to get rid of duplicates too? Maybe a virtual column..
Maybe try the following instead:
[keycolumn] = MINROW("OfficialApps", "_ROWNUMBER", [UserEmail] = USEREMAIL())
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |