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

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

        Coryanthony 

        PTE/CB/GM Count = IF(COUNT(PTE_CB_GM[Number])>=0,2,COUNT(PTE_CB_GM[Number]))

        SNOW Case Count = IF(COUNT(Count(SNOW[Number])>=0,4,Count(SNOW[Number]))
        **************************************************************************************************

        Measures: 

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

        SNOW Case Count = Count(SNOW[Number])

        Measure 1 = IF([PTE/CB/GM Count]>=0,2)
        Measure 2 = IF([SNOW Case Count]>=0,4)

        THANK YOU!!