if statement lookup

[Anonymous]

i need a formula like this 

if an employee has in column Action ONLY "plan"= 1 otherwise 2.  see picture below.

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

You could also use this formula

Result Column = 
IF (
    'Table'[Action] = "Plan"
        && CALCULATE (
            COUNTA ( 'Table'[Action] ),
            FILTER ( 'Table', 'Table'[Name employee] = EARLIER ( 'Table'[Name employee] ) )
        ) = 1,
    1,
    2
)

Result:

Best Regards,

Lin

[tex628]

IF(
CALCULATE(
SELECTEDVALUE([Action]) , 
ALL('Table'),
[Employee name] = EARLIER([Employee name])
) = "Plan" , 1 , 0 )