Forum Discussion

Balaraju's avatar
Balaraju
Helper III
4 years ago
Solved

I Need Geo Continent In card with Multiple Names

Hi All Good Morning

 

I have Geo Continent Column in my table Using that column as filter but I need to see Geo continent Name at top of the report as text when I am selecting Particular Geo continent .

 

For that I wrote one Measure:

Geo Continent Name = if(isfiltered('Table'[Geo Continent]), selectedvalue('Table'[Geo Continent]), " ")

It is working for single Selection But when I am going two do multiple selection I want to see Multiple Names. Now it is showing Blank Could you please help me on that.

 

 

Need Help
  • moizsherwani's avatar
    moizsherwani
    4 years ago

    See if this works for you

     

    SelectedContinent =
IF (
    ISFILTERED ( SampleTable[Geo Continent] ),
    "Continent:"
        & CONCATENATEX (
            ALLSELECTED ( 'SampleTable'[Geo Continent] ),
            UNICHAR ( 9989 ) & 'SampleTable'[Geo Continent],
            ","
        ),
    ""
)

     

     

2 Replies

  • moizsherwani's avatar
    moizsherwani
    Continued Contributor
    4 years ago

    See if this works for you

     

    SelectedContinent =
IF (
    ISFILTERED ( SampleTable[Geo Continent] ),
    "Continent:"
        & CONCATENATEX (
            ALLSELECTED ( 'SampleTable'[Geo Continent] ),
            UNICHAR ( 9989 ) & 'SampleTable'[Geo Continent],
            ","
        ),
    ""
)

     

     

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    4 years ago

    Hi Balaraju ,

     

    Please try this:-

    Geo =
IF (
    ISFILTERED ( 'Table'[Geo Continent] ),
    CONCATENATEX ( VALUES ( 'Table'[Geo Continent] ), [Geo Continent], " " )
)

     

    Thanks,

    Samarth