topic Issue with SWITCH Measure giving incorrect value in DAX Commands and Tips

Issue with SWITCH Measure giving incorrect value

JamHam — Wed, 16 Aug 2023 17:26:32 GMT

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.

Re: Issue with SWITCH Measure giving incorrect value

mlsx4 — Thu, 17 Aug 2023 06:47:42 GMT

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() )

Re: Issue with SWITCH Measure giving incorrect value

JamHam — Thu, 17 Aug 2023 15:41:42 GMT

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.

Re: Issue with SWITCH Measure giving incorrect value

mlsx4 — Fri, 18 Aug 2023 06:19:04 GMT

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?

Re: Issue with SWITCH Measure giving incorrect value

JamHam — Fri, 18 Aug 2023 16:03:42 GMT

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!