Solved: Linktofilteredview() and lists of ref_rows - Page 2

Sean_Lim · 01-19-2020 11:03 PM

Hello, I have a conundrum that may have a simple solution that I’m simply not seeing.

There are two tables:
Table A with column A (key) and column B (text)
Table B with column C (ref_rows of Table A)

I’m making an action for Table B to “go to another view within this app”

The action uses Linktofilteredview(“Table A View”, IN([Column A].[Column B], [Column C][Column B])

Why is this not working? It should be easy for Table A to give me rows that have its Column B value in the ref_row list [Column C][Column B]

Sean_Lim

Thank you for all yall help.

What worked for me was Linktofilteredview(“Table A View”, IN([Column B], SELECT(Table A[Column B], [Table B Key] = [_THISROW].[Table B Key])

The intention of the action is quite complex. It shows all of the related rows in Table A that has a reference row in Table B (whose key is [Table B Key]) as the current row in Table B. Table A has a column with Table B Key as a REF column.

View solution in original post