Forum Discussion

JamHam's avatar
JamHam
Frequent Visitor
3 years ago
Solved

Issue with SWITCH Measure giving incorrect value

Hello,   I am attempting to create a SWITCH measure that will return a value for a specific group of Item/SKU numbers. But when I add the measure I want to use the SWITCH function for it is giving ...
  • mlsx4's avatar
    mlsx4
    3 years ago

    Sorry, it should be like this:

     

    SWITCH - Select SKUs - UPH =

VAR MySelection = SELECTEDVALUE('devSKUSummary'[SkuNumber])

RETURN 
SWITCH(MySelection,
"12761", CALCULATE([UPH Calc],'devSKUSummary'[SkuNumber]= "12761"),
"12762", CALCULATE([UPH Calc],'devSKUSummary'[SkuNumber]= "12762"),
"12763",CALCULATE([UPH Calc],'devSKUSummary'[SkuNumber]= "12763"),
"21282", CALCULATE([UPH Calc],'devSKUSummary'[SkuNumber]= "21282"),
BLANK()
)

     

    Anyway, if it doesn't work, can you post here some dummy data to check?