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
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!!

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

      Coryanthony  you want to under PTE/CB/GM Every value consider as 2 and Snow Value as 4 ,i'm right or wrong .Plaese Guide Further.