Calculate based on multiple criteria

[Qotsa]

Hi,

How can this measure be modified to subtract 21 if LOT NUM >5 but not equal to 8

Avg Hrs Var = CALCULATE([Average Hrs Worked] - 23,vw_ShiftsAll[LOT Num] <=5 || vw_ShiftsAll[LOT Num] =8)

[Zubair_Muhammad]

@Qotsa 

Try

Avg Hrs Var =
CALCULATE (
    [Average Hrs Worked] - 21,
    vw_ShiftsAll[LOT Num] > 5
        && vw_ShiftsAll[LOT Num] <> 8
)

[Qotsa]

Hi,

Thks for the reply.

I was looking to combine the 2.

Something like:

If LOT Num <= 5 & <> 9 then subtract 23 

else if LOT Num > 5 & <> 8 then subtract 21.

[Zubair_Muhammad · Accepted solution]

@Qotsa 

You can use SWITCH function

A pattern like following

=
VAR myvalue =
    SELECTEDVALUE ( vw_ShiftsAll[LOT Num] )
RETURN
    SWITCH ( TRUE (), myvalue > 6 && myalue <> 8, [Formula1], [Formula2] )

[Qotsa]

Yeah, that work perfectly. Thanks a million.