Forum Discussion

Coryanthony's avatar
Coryanthony
Icon for Helper III rankHelper III
3 years ago

Measure help (Brain fog)

Hello, 

I need to create a "target per hour " measure and I am completely stuck. 

 

If PTE/GM/CB Case, then 2 per hour

if SNOW Case, then 4 per hour.

 

The PTE/GM/CB and SNOW cases are different table. 

 

 

Please Help. Thank you 

 

 

 

 

Need Help

7 Replies

  • Mahesh0016's avatar
    Mahesh0016
    Icon for Super User rankSuper User
    3 years ago

    Coryanthony  Please Try Below Code

    Test =
    SWITCH (
    SELECTEDVALUE ( Table[column] ),
    "PTE/GM/CB Case", 2,
    "SNOW Case", 4,
    [Defualt Measure]
    )



    Coryanthony If this post helps, then please consider accepting it as the solution to help other members find it more quickly.

    • Coryanthony's avatar
      Coryanthony
      Icon for Helper III rankHelper III
      3 years ago

      Hi Mahesh0016 , thank you for your response. the solution does not appear to be working. Please see my current measure for "PTE/CB/GM Count" and "SNOW case count". Hopefully this provides additional information and helps. Thanks again. 

       

      Measures: 

      PTE/CB/GM Count = COUNT(PTE_CB_GM[Number])

      SNOW Case Count = Count(SNOW[Number])