LinkedIn
Twitter
I have a virtual column in Table A that uses FILTER() to display a slice of Table B:
FILTER(
"Slice of Table B",
IN( [_THISROW].[Table A Row Key], [List of Table A Row Keys] )
)
Each row of Table B has a column with a list of Table A row keys (a List of Refs with Table A as the base table). When I use the expression above, the resultant table shows the correct number of rows, but the Table View does not show the rows. This happens both in the inline table and in the dedicated Table view.
When I wrap the IN() expression in an AND() i.e. AND( IN(), TRUE ) it suddenly works as expected and displays the rows:
FILTER(
"Slice of Table B",
AND( IN( [_THISROW].[Table A Row Key], [List of Table A Row Keys] ), TRUE)
)
I should also note that replacing the IN() with something else (e.g. TRUE) or another expression also displays the rows.
Solved
1 ACCEPTED SOLUTION
