IFS contain ... row filter by email

[aminsaleh]

Hello there, I hope all is good

I want to do slice row filter condition

I have driver column which is of type ref to workers table.

I also have inspector column which is of type ref to workers table as well.

I have a task column of enumlist value. (contains delivery, inspection .....)

-----

I want to make ifs expression where if task contains for example delivery .. then filter only email of the driver.

I  tried this today but did not work

IFS( CONTAINS( [Task] , 'Inspection' ) ,

USEREMAIL()=[worker].[Email]

)

[AleksiAlkio]

If you need it to be TRUE, should you then use word "Delivery" instead of "Inspection" with your formula?

[jaichith]

Please share the table, slice, and expression screen shots. 

for my understanding IF Enum List [Task] = "INSPECTION", then return workers email id. Is this Right?

I think

1. USERMAIL () returns current app user email id not some others email id. 

2. As @AleksiAlkio said, the condition should be true.

[aminsaleh]

@jaichith  @AleksiAlkio 

Thank you all guys 

plz see kindly below image for elaboration

 

[Sirfyaad]

Hi @aminsaleh 

IFS(
CONTAINS([Task], "Delivery"),
[Driver].[Email] = USEREMAIL(),
CONTAINS([Task], "Inspection"),
[Inspector].[Email] = USEREMAIL(),
TRUE
)

[jaichith]

Ifs(

(Table1[Task]= "Delivery", [Email] = (any(Driver[email]),  

(Table1[Task]= "inspection", [Email] = (any(inspector[email]),

(Table1[Task]= "Delivery", [Email] = (any(helper[email])

)

[jaichith]

Please share  screen shots of tables And Data source .

[AleksiAlkio · Accepted solution]

In your case, could it be just as simple as..
IN(
USEREMAIL(),
LIST([Driver].[Email],[Inspector].[Email],[Helper].[Email])
)

[aminsaleh]

@AleksiAlkio 

Thanks all, your solution's solved it and I also have found this is also ok

Ifs(
CONTAINS( [Task] , "Delivery"),
IN(USEREMAIL(),Driver CA[Email]),

CONTAINS( [Task] , "Return"),
IN(USEREMAIL(),Return Driver[Email]),
)

Thanks indeed