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?

mlsx4's avatar
mlsx4
Memorable Member
3 years ago

Hi JamHam 

 

I have not really understood what you want to do, but if you want to retrieve the value only for selected SKU, then you could do something like this:

 

SWITCH - Select SKUs - UPH =
SWITCH('devSKUSummary'[SkuNumber],
"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()
)

 

JamHam's avatar
JamHam
Frequent Visitor
3 years ago

Thank you for the reply. I am attempting to build a measure that pulls UPH for specific skus. Instead of using filters to get the same result. When I look at the sku level the SWITCH calc shows a different number than the UPH calc. Which I would expect the same number to be displayed for the SWITCH and UPH calc. So I am not really sure what would cause this issue.

 

I attempted to use your updated SWTICH Calc. But it is giving an error on the 'devSKUSummary' [SKUNumber]. Power BI states that it "Cannot Find Name [SKUNumber]". Additionally when I try to enter the calc manually the [SKUNumber] does not show up as an option when I type 'dev in the calc. It is only showing measures being able to be selected.

  • mlsx4's avatar
    mlsx4
    Memorable Member
    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?

    • JamHam's avatar
      JamHam
      Frequent Visitor
      3 years ago

      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!