Create measure for when there is more than one answer

[Syndicate_Admin]

Hi, I'm pretty new to using Power BI and I'm not being able to solve the following issue:

I have a database of cities in countries of the world, I added to my dashboard a card that shows the capital city of the selected country. The problem is, when I'm on "select all", this card shows me the capital of the first country on the list. How do I make it appear blank or show a text of your choice when all the cities are selected?

Thank you!

[MahyarTF · Accepted solution]

Hi,

In my opinion you could create the below measure :

_NewCapital =

Var _SelectVal = count(Sheet161[Capital])

return if(_SelectVal = 1, values(Sheet161[Capital]), BLANK())

Then use this measure as your card visual :

Appreciate your Kudos 

[Syndicate_Admin]

It worked thank you very much!!

[MahyarTF]

Thanks for your Kudos,

Would you please mark it as a solution if it helps you ?

[MahyarTF]

Would you please set it as a solution and Kudos please ?