Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculate based on multiple criteria

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)
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous 

     

    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] )

     

4 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    7 years ago

    Anonymous 

     

    Try

     

    Avg Hrs Var =
CALCULATE (
    [Average Hrs Worked] - 21,
    vw_ShiftsAll[LOT Num] > 5
        && vw_ShiftsAll[LOT Num] <> 8
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        Zubair_Muhammad
        Community Champion
        7 years ago

        Anonymous 

         

        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] )