How to get the text when multiple values are picked in a slicer?

[Anonymous]

Hello, I have the following DAX code that returns a single value like "St. Louis". The intent is to fill a card visualization with the values. 

_M_AgencyName = 
    VAR crazyStuff = SELECTEDVALUE(Office[Agency Name], blank())
    RETURN
    SWITCH(crazyStuff, 
        "St.Louis", "St. Louis",
        "Omaha", "Omaha",
        "Kansas City", "Kansas City",
        "Phoenix", "Phoenix",
        "Chicago", "Chicago",
        Blank(), "All"
        )

But what if there is more than one value selected in the slicer? I just want the text, something like "Chicago, St. Louis, Omaha" if that's what is selected. So I tried this code, but it didn't work. All the other posts I have found are not helpful.

_M both = 
VAR allofthem = ALLSELECTED(Office[Agency Name])
RETURN allofthem

Thanks!

[PaulDBrown · Accepted solution]

Try:

Selected locations =
VAR _Selected =
    CONCATENATEX (
        VALUES ( 'Slicer table'[Location] ),
        'Slicer table'[Location],
        ", "
    )
RETURN
    "Selected Location(s): " & _Selected