How to get concatenated values of a column in a measure based on a different column filter

[Sreya]

I am facing issues while trying to concatenate values of a column in a measure based on a different column filter.

Suppose I want to concatenate all the EngagementPartner Values based on selected Engagements so what should be the DAX? User can choose single or multiple Engagements.

I wrote the below measure but it is not getting filtered with the engagement values.

EngagementPartner List=

VAR EP_Concat = CONCATENATEX(VALUES('Staff-EngagementPartner'[BestFullName]),[BestFullName]," , ")

Return

IF(ISFILTERED(Engagement[EngagementName]),UNICHAR(10)&EP_Concat,"ALL")

Not sure how to pass Engagement filter so that it would show just associated EngagementPartner names. User can select single,all,multiple engagements.

[amitchandak]

@Sreya ,

Add calculate and filter

calculate(CONCATENATEX(VALUES('Staff-EngagementPartner'[BestFullName]),[BestFullName]," , "),

filter(Engagement, Engagement[EngagementName] ="ABC"))

hope Staff-EngagementPartner is joined with Engagement

[Sreya]

@amitchandak Thanks for your reply... it is working for single Engagement Value but how it would work with dynamically multiple selected value ?