cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ldunbarmtd
Frequent Visitor

SWITCH Statement to select between two columns

Hello,

 

Perhaps this is not the right way to approach this, but here goes:

 

I have a column, let's call it "SBU".  

There are two other columns that are part of an item hierarchy. Let's call them "Family" and "Group".  I want to include this item hierarchy as a filter; however, which column I want to use, depends on the division.

 

If SBU is "US", I want to use "Family".

If SBU is "CAN", I want to use "Family".

Otherwise, I want to use "Group".

 

Here is what I tried:

 

 

EXAMPLE = SWITCH(
SELECTEDVALUE('SBU DIVISION'[SBU]),
"US",VALUES(Items[FAMILY]),
"CAN",VALUES(Items[FAMILY]),
VALUES(Items[GROUP]))

 

 
I've also replaced "VALUES" with "ALL".  
 
Thanks in advance!
 
2 REPLIES 2
v-yuaj-msft
Community Support
Community Support

Hi @ldunbarmtd ,

 

Maybe I'm not getting what actually you are trying to do.

Could you please share some sample data and the expected result to have a clear understanding of your question? I can do some tests for you.

You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.

 

Best Regards,

Yuna

Greg_Deckler
Super User IV
Super User IV

@ldunbarmtd It looks as if you are trying to return a table of values in a measure. You can't do that. Perhaps you can explain better what you are trying to achieve. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors