Switch statement

[reendzz98]

I want to create another column - Tier in my dashboard and below is the switch statement that I have queried:

tier_testing = SWITCH(
OFFICE[Sales] > 500, "Tier 1", 
OFFICE[Sales] >= 300 && SMS_TBL_MeSSP_AQIR_Fact_Infotech_Financials[Total Sales Measure] < 500, "Tier 2",
OFFICE[Total Sales Measure] >= 200 && OFFICE[Sales] < 300, "Tier 3",
OFFICE[Total Sales Measure] >=0 && OFFICE[Sales] < 200, "Tier 4")

The problem is that, whan I insert this measure in to the table, it cant read, and I think most probably because I didnt include the currency RM in my DAX. Anyone can help me to resolve this problem? I want to know how to include the currency in my DAX query.

[reendzz98 · Accepted solution]

@tamerj1 Thank you for your respond.  I have figured out the way to do it using multiple IF statement

[tamerj1]

Hi @reendzz98 

please change OFFICE[Sales] to SUM(OFFICE[Sales]). The rest I belive are measures so there should be no problem. 

[reendzz98]

Hi @tamerj1 

thank you for your respond. I forgot to mention that [Sales] is actually a measure result from another measure. Does that affect my switch statement?

[tamerj1]

What results are you getting?can you share a screenshot?

[reendzz98]

this is the name of the table and column that i actually used and as I add SUM, the red line appears 

[tamerj1]

@reendzz98 
I mean the original results before adding SUM. Of course you cannot sum a measure

[reendzz98]

I couldnt display anything from the first time i did the switch statement. I tried using if statement, it did work but I can only display one of the tiers. 

tier_testing1 = IF(SMS_TBL_MeSSP_AQIR_Fact_Infotech_Financials[Total Sales Measure] >= 60000000, "Tier 1")

[Anonymous]

Hi @reendzz98 

Please try nested if statement.

Regards,

Ashfiya