Hi All
Iโm struggling to get an EnumList which is filtered.
I have a table
Dept a@b.com Production b@b.com Production c@b.com Production d@b.com Warehouse e@b.com Warehouse
How do i construct the ValidIf statement to get Production department members to only see members of Production and not Warehouse? (and vice versa!)
Iโm looking at SELECT([Email],[Dept]=โthe same department as USEREMAIL()โ)
All help appreciated! Thanks Gordon
Try withโฆ SELECT(YourTableName[Email],[Dept]=LOOKUP(USEREMAIL(),TableName,Email,Dept))
Thanks!
I guess you will use it on a slice or a security filter, if so then use this [dept] = LOOKUP(USERMAIL(), yourtable, email, dept)
@Fernando_Lopez He wanted to have filtered Enumlist.
Ohhhh, OK
Thanks everyone - Iโve implemented Aleksiโs suggestion successfully. This gives my colleagues the option to select their own department members in an EnumList, but not any other departments. Perfect
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |