Measure help (Brain fog)

[Coryanthony]

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 

[Mahesh0016]

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

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]

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

[Coryanthony]

@Mahesh0016 Hi, please see below. Thaank you 

[Mahesh0016]

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

[Coryanthony]

 hi @Mahesh0016 

that is correct

[Mahesh0016]

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