Forum Discussion

reendzz98's avatar
reendzz98
Icon for Helper I rankHelper 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

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity 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
Icon for Helper I rankHelper 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
    Icon for Community Champion rankCommunity Champion
    4 years ago

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

    • reendzz98's avatar
      reendzz98
      Icon for Helper I rankHelper 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
        Icon for Community Champion rankCommunity Champion
        4 years ago

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