CONCATENATEX and Using Slicer Value in FILTER

Hi All

In this example, I have collected the results of people's hobbies based on expert, proficient or interested.

Currently, I am facing 2 issues which I have looked at but struggling to solve.

1) I have used ConcatenateX to join up all their hobbies they have selected but the delimiter still appears for blank values. (Solved)

2) For my Expert Hobbie measure, I have hard coded the filter as 'tennis' but can this be from a slicer? I saw PBI have something called selectedvalue but Excel doesn't seem to have this feature

The aim for this report is, if I select Tennis in the slicer, it shows me the list of people who are either expert or proficient or interested in tennis.

Many thanks!

Attached the sample file I have been trying to work out....

Please try

=CONCATENATEX(FILTER(DATA,DATA[Interested]<>""),DATA[Interested],", ")

Q2

=CONCATENATEX(Filter(data,DATA[Expert] in ALLSELECTED(Lookup[Sport] )),DATA[Expert],", ")