Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
JamHam
Frequent Visitor

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.

 

SWITCH incorrect value.png

 

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.

1 ACCEPTED SOLUTION

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?

View solution in original post

4 REPLIES 4
mlsx4
Super User
Super User

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
Frequent Visitor

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.

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
Frequent Visitor

@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()
)
 
New SWITCH calc.png
 
 
Thank you again for your help and have a great weekend!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors