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! Go to Solution.
Sorry your experience with support has been so discouraging. I was able to reproduce the problem with this kind of expression and I see whatโs going wrong, so I think we should be able to get a fix out within a few days.
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |