Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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=
@Sreya ,
Add calculate and filter
calculate(CONCATENATEX(VALUES('Staff-EngagementPartner'[BestFullName]),[BestFullName]," , "),
filter(Engagement, Engagement[EngagementName] ="ABC"))
hope Staff-EngagementPartner is joined with Engagement
@amitchandak Thanks for your reply... it is working for single Engagement Value but how it would work with dynamically multiple selected value ?
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |