Conditional values in calculated column

[SelvakumaranM]

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

[v-janeyg-msft]

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

[parry2k]

@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.