Dynamic values in text field - getting from drop down

[StephenF]

Im getting values for a dynamic text field from a SLICER dropdown.

Im able to get  the text "ALL" and individual single item names but not a list when multiple items are selected - "All" is returned.

Is there a way to rewrite my function here from

Selected Media = SELECTEDVALUE('DataLake'[Media],"All Media")

In such as a way as this

if selected media is multiple items return a list else if a single item return that item only else return "all".

[amitchandak · Accepted solution]

@StephenF , Based on what I got

if(isfiltered('DataLake'[Media]) , concatenatex('DataLake', 'DataLake'[Media], ", ") ,"All Media" )

[amitchandak · Accepted solution]

@StephenF , Based on what I got

if(isfiltered('DataLake'[Media]) , concatenatex('DataLake', 'DataLake'[Media], ", ") ,"All Media" )

[StephenF · Accepted solution]

That sort of works but it outputs thousands of values. I need it to rollup the values. There is only 5 different distinct values in my dropdown.

I think it needs to work with DISTINCT but i can't get the syntax right, any idea?.

Edit: working code is :

Selected Media plus = if(isfiltered('DataLake'[Media]) , calculate(concatenatex(VALUES('DataLake'[Media]), 'DataLake'[Media], ", " ,"All Media" )))