Forum Discussion

reendzz98's avatar
reendzz98
Helper I
4 years ago
Solved

Switch statement

 

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's avatar
    reendzz98
    4 years ago

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

8 Replies

  • reendzz98's avatar
    reendzz98
    Helper I
    4 years ago

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

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Hi reendzz98 

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

    • reendzz98's avatar
      reendzz98
      Helper I
      4 years ago

      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's avatar
        tamerj1
        Community Champion
        4 years ago

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