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

 

 

Below are the calculations for UPH and SWITCH (only included partial list of Items/SKUs).

 

UPH Calc =
DIVIDE(sum('devSKUSummary'[UnitsSold]),[All Traffic])*100
 
SWITCH - Select SKUs - UPH =
CALCULATE([UPH Calc],
SWITCH('devSKUSummary'[SkuNumber],
"12761", TRUE(),
"12762", TRUE(),
"12763", TRUE(),
"21282", TRUE(),
FALSE()
))

 

Goal is to have the UPH measures mirror each other. I am fairly new to Power BI and may be using the SWITCH funchtion incorrectly.

 

Thank you for the assistance.

  • 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?

4 Replies

  • 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?