Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@tamerj1 Thank you for your respond. I have figured out the way to do it using multiple IF statement
@tamerj1 Thank you for your respond. I have figured out the way to do it using multiple IF statement
Hi @reendzz98
please change OFFICE[Sales] to SUM(OFFICE[Sales]). The rest I belive are measures so there should be no problem.
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?
What results are you getting?can you share a screenshot?
this is the name of the table and column that i actually used and as I add SUM, the red line appears
@reendzz98
I mean the original results before adding SUM. Of course you cannot sum a measure
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")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
77 | |
50 | |
46 | |
16 | |
12 |