cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
damit23183
Microsoft
Microsoft

Need help with SWITCH funtion

Hi, 

I need some help in creating SWITCH funtion which is nothing but CASE statement in POWERBI.

SWITCH funtion has used to calculate final output based on conditions and values will be come from different tables.

 

Source:

Name (Table0) 

USA, UK , Canada 

 

Values1: 

Table 1: 

Score1Measure: 4000 for USA

 

Values2: 

Table 2: 

Score2Measure: 1 for UK

 

Values3: 

Table 3: 

Score3Measure: 0 for CANADA

 

After applying Switch funtion like below;

 

SWITCH(TRUE(),'Table'[Name]="USA",[Score1Measure], 
'Table'[Name]="UK",[Score2Measure], 
'Table'[Name]= "Canada",[Score3Measure],
 0)

it gave me wrong output as shown in table below. USA should have 3000. It does look like automatically average out but i checked data type and summary which is SUM. Not sure what could be wrong here. Any advise would be appreciated!

 

OUTPUT :

 Table: 

 

Name                              Score

USA                                  3000

UK                                         1

Canada                                  0

 

 

 

2 REPLIES 2
amitchandak
Super User
Super User

The switch across the table needs aggregated values from other tables. Can you share some better sample data and sample output?

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

There are total 3 Tables in data PowerBI data model;

1) Fact_Incident

2) Delivery 

3) Customer Experience

 

These are the following data and columns in each table

Fact_Incident Table:

TAT Time --> (Column Name)

1

 

Delivery Table:

No of Enhance                No. of sustain      -->(Column Name)

3000                                     445

 

Custom Table: (This is out put table where Score is empty)

Name              Score    -->(Column Name)

USA

UK

Canada

 

After SWITCH or any CASE function i would like to see table as below;

 

Custom Table: (Fianl Output)

Name              Score    -->(Column Name)

Enhance             3000

Sustain                445

TAT                        1

 

Hope this will give you more detail.

 

NOTE: There is no relationship between source table and output table this is just case statement i would like to use here and put whatever value is there in source.

 

Thanks

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.