Forum Discussion
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 ...
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?
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?
mlsx4 Your latest Measure got me close to what I needed. I had to add the UPH Calc into the measure to get it to work. But now the results are reporting correctly.
NEW - SWITCH - Select SKUs - UPH =
VAR MySelection = SELECTEDVALUE('devSKUSummary'[SkuNumber])
VAR UPH = DIVIDE(sum('devSKUSummary'[UnitsSold]),[All Traffic])*100
RETURN
SWITCH(MySelection,
"12761", CALCULATE(UPH,'devSKUSummary'[SkuNumber]= "12761"),
"12762", CALCULATE(UPH,'devSKUSummary'[SkuNumber]= "12762"),
"12763", CALCULATE(UPH,'devSKUSummary'[SkuNumber]= "12763"),
"21282", CALCULATE(UPH,'devSKUSummary'[SkuNumber]= "21282"),
BLANK()
)
Thank you again for your help and have a great weekend!