I'm trying to match companies based on countries in which they operate. If Company A operates in "Australia, Germany", I'd like the list of other (multiple) companies that also operate in "Australia, Germany".
A select statement matching single values SELECT(Customers[Customer],([Industry] = [_THISROW].[Industry])) - easy.
I cannot get a Table A[Virtual List] = [_THISROW].[Virtual List] to work.
Likewise, I cannot store the list (as text) and get it to work. LIST(Table A[TEXT]) = [_THISROW].[Virtual List].
I'm sure I've tried [LIST as TEXT] = [LIST as TEXT] and also failed. What am I missing?
LinkedIn
Twitter
