In DAX, how do you return a a set of matching rows and concatenate one of the columns?

[alex1alex]

I want to do something like
=related(othertable[aColumn])
but where there are multiple matching rows and therefore, you concatenate all of the aColumn values that match the rows.
something like the below but which works
=concatenate( TO LIST ( values(filter(othertable,othertable[bColumn]=[value in this table]))))

 

[scottsen]

I think there are two problems here:
1) There is no ConcatenateX function, which would totally rule.
2) I'm skeptical that RELATED() can be doing what you are saying? The relationship is many to 1... you are on the many side (the fact/data table), it should only match exactly 1 row in the Lookup table?

If you are going the OTHER way (from Lookup Table to Fact Table), it would be RELATEDTABLE(othertable), but then... you have to aggregate that, and again, there is no ConcatX

 

[alex1alex]

Yeah, I agree that there's no obvious way to do this.
Agree about the RELATED not working because of the 1:many.
But the filter combined with, say, countrow will do a 1:many match and return a table (which the countrow then...er...counts . There should be a way to say, filter, then return the table...then take one of the columns and convert to a list. I'm a bit of a newbie when it comes to DAX though.
Thanks for the response. At least if rules out any obvious answers

 

[alex1alex]

FYI: I solved this in the Power Query part of my solution:
http://www.mrexcel.com/forum/power-...then-concatenate-instead-sum-one-columns.html