Auto compute List filtered by another EnumList

Hey so I have been trying to solve this problem for days now and I can't find a solution yet. 

So I have the following tables and columns

tableA[column1] - key

tableA[column2] - non labeled column

tableB[column1] - Enumlist Ref 

tableB[column2] - I want to Autocompute the list of tableA[Column2] (this is currently config as Enumlist base List)

 

So my initial though was like this: 

SELECT(tableA[column2],IN([_THISROW].[column1]=tableA[column1])

however this doesn't work and I understand because the IN expression allows to search 1 text within a list, so what I would like to know is how to retrieve a new list based on another list.

 

Appreciate you all for the support

 

Solved Solved
0 2 55
1 ACCEPTED SOLUTION

Maybe this one?

SELECT(Table A[column2], IN([column1], [_THISROW].[column1]))

View solution in original post

2 REPLIES 2

Maybe this one?

SELECT(Table A[column2], IN([column1], [_THISROW].[column1]))

This was so simple that I feel dumb now, thank you so much @chansol 

Top Labels in this Space