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 differen...
Need Help
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])
    • Mahesh0016's avatar
      Mahesh0016
      Icon for Super User rankSuper User
      3 years ago

      Coryanthony Please Share expected Output in table formatted.THANK YOU!!

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

        Mahesh0016 Hi, please see below. Thaank you