topic Re: Switch statement in DAX Commands and Tips

Switch statement

reendzz98 — Wed, 18 May 2022 01:46:40 GMT

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.

Re: Switch statement

tamerj1 — Wed, 18 May 2022 03:16:23 GMT

Hi reendzz98

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

Re: Switch statement

reendzz98 — Wed, 18 May 2022 03:20:39 GMT

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?

Re: Switch statement

tamerj1 — Wed, 18 May 2022 03:22:19 GMT

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

Re: Switch statement

reendzz98 — Wed, 18 May 2022 03:28:35 GMT

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

Re: Switch statement

tamerj1 — Wed, 18 May 2022 03:37:06 GMT

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

Re: Switch statement

reendzz98 — Wed, 18 May 2022 03:42:02 GMT

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")

Re: Switch statement

reendzz98 — Wed, 18 May 2022 04:27:30 GMT

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

Re: Switch statement

Anonymous — Fri, 19 Aug 2022 05:42:22 GMT

Hi reendzz98

Please try nested if statement.

Regards,

Ashfiya