Card Shows Blank Value in case of Multiple Selection

[powerBI21]

Hi All

Here is the Scenario:

I have Region and Country Filter on my page and a Card which shows the selected Region or country.

If no selection is made- -> Card shows Blank value which I fixed with COALESCE function ensuring if nothing is selected, the Card shows " No Country Selected".

Code used - 

Selected Country = COALESCE((SELECTEDVALUE(
'Consolidated'[Country])),"No Country Selected")

But if multiple selection is made, card again shows Blank Value.

Please help me fix this as I want in case of multiple selection, card shows Mutiple Countries Selected.

Thanks in Advance!!

Happy Learning.

[rsbin · Accepted solution]

@powerBI21 ,

I use the SWITCH funtion to do this:

Country_Selected = SWITCH(
                   TRUE(),
   ISFILTERED( 'Consolidated'[Country] ) = FALSE(), "No Country Selected",
   HASONEFILTER( 'Consolidated'[Country] ) = TRUE(), SELECTEDVALUE( 'Consolidated'[Country] ),
   "Multiple Countries Selected" )

Trust this will work for you.

Regards,

[Anuja_Chaudhari]

[Hema_Gupta]

Hi ,

Hope this helps.

[powerBI21]

Thank you so much. This helps.