Need Dax Help Please!

[Bpark1994]

Hi guys,

Here is my starting table im pulling into power bi:

User	Task
john	70
jim	70
john	71
john	30

I want to write a dax function called Qualified that says if a user has both task 70 and task 71 then YES else NO

This is a simplified example but in some cases there will be many conditions being evaluated so just want to know the best way to write this dax function. 

Desired end result:

User	Qualified?
john	YES
jim	NO

Thanks!

[CNENFRNL]

@Bpark1994 , here's an extended model addressing your question. By choosing one or more tasks to test if a candidate is qualified or not; those who have all the chosen task(s) in the slicer are qualified.

[wdx223_Daniel]

measure=if(sumx({70,71},if([value] in values(table[task]),1))=2,"yes","no")

[nandic]

Hi,
Could you try this formula:

Concatenax Value =
VAR Concat =
    CALCULATE (
        CONCATENATEX ( 'Table', 'Table'[Task], "," ),
        ALLEXCEPT ( 'Table', 'Table'[User] )
    )
RETURN
    IF (
        AND ( CONTAINSSTRING ( Concat, "70" ), CONTAINSSTRING ( Concat, 71 ) ),
        "Yes",
        "No"
    )

Attached demo file.

Regards,
Nemanja Andic