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 &&...
  • 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

reendzz98's avatar
reendzz98
Helper I
4 years ago

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

tamerj1's avatar
tamerj1
Community Champion
4 years ago

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

  • reendzz98's avatar
    reendzz98
    Helper I
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi reendzz98 

      Please try nested if statement.

       

      Regards,

      Ashfiya