Forum Discussion

SelvakumaranM's avatar
SelvakumaranM
Frequent Visitor
4 years ago

Conditional values in calculated column

Hi Experts,

 

I have create a calcualted column like below

city group = SWITCH(
TRUE(),
SELECTEDVALUE(Orders[City - Copy]) in {"Columbus","San Francisco"},"Columbus/san",
SELECTEDVALUE(Orders[City - Copy]) in {"New York City","Clinton"},"New/Clinton",
SELECTEDVALUE(Orders[City - Copy]) in {"Texas","Dublin"},"Tex/Dub",
SELECTEDVALUE(Orders[City - Copy]) in {"Washington","Oregon"},"wash/oregon",
"NA")

i need to take values from sales column for Dublin, Washington, Columbus and New York City only . when i create an IF condition and put in table, it shows zero values for all . Pls clarify

 

 

Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    SelvakumaranM change your city group column

    city group =
VAR __city = Orders[City - Copy]
RETURN
 SWITCH(
TRUE(),
__city in {"Columbus","San Francisco"},"Columbus/san",
__city  in {"New York City","Clinton"},"New/Clinton",
__city  in {"Texas","Dublin"},"Tex/Dub",
__city  in {"Washington","Oregon"},"wash/oregon",
"NA")

     

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

     

    Learn about conditional formatting at Microsoft Reactor

    My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    4 years ago

    Hi, SelvakumaranM 

     

    First, calculated columns usually don't need to use SELECTEDVALUE(), you can directly use the column name to represent the value of the current row, just like parry2k  wrote. Is your problem solved?

     

     

    i need to take values from sales column for Dublin, Washington, Columbus and New York City only . when i create an IF condition and put in table, it shows zero values for all . 

     

    But I don't know what you mean by demand in your last sentence. Your calculated column displayed the combined result, but you mentioned a series of single cities, can you explain it?

     

    Did I answer your question? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.

     

    Best Regards,

    Community Support Team _Janey