DAX: help with formula

[Anonymous]

Hi Guys,

I have been trying (for too long) some time now to get the following working.

I have 3 tables

1. ObjectID and Title

2. Relations ObjectID, ObjectID and RelationRemark

3. ObjectID and Title (copy of table 1)

For a specific RelationRemark; "admin" i want to create an messure to table 1.

However there can be 1 or multiple admins. The result should all be in 1 cell. So it will look like:

1,Ttile : Admin (2,RelationRemark)

1,Ttile : 3,Title , 3,Ttile , 3,Ttile, Etc

Is this possible and any suggestions are welcome.

Thanks!

[v-xicai]

Hi @Anonymous ,

You may create measure like DAX below.

Measure1 =CONCATENATEX (FILTER(Table2, Table2[ObjectID]=Table1[ObjectID]),Table2[RelationRemark],", ")

If I misunderstood it, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Thanks Amy. You pointed me in the right direction. The below DAX messure did the trick:

CONCATENATEX(FILTER(Table2;Table2[ObjectId]=RELATED(Table3[ObjectID]) && Table2[Remark]= "ADMIN"); RELATED(Table3[Title]);", ")