Select using ID of a reference column

[adambc]

Hello,

I am trying to do a select that uses the ID of reference column, but cannot get it work.

ANY(
SELECT(
Result[ID],
[Parent_ID] =
TEXT([Prev Parent Record].[ID])
)
)

[Prev Parent Record].[ID] is the key value of the table. I believe this has something to do with the issue.

Any help would be appreciated.