Comare to column other than key column

In the below condition, I want Virtual Queue[Facility] to be compared to Facility[Facility] instead of Facility[_ComputedKey]

2 Likes

Thanks Steve!

This is the code I used:
IN
([Facility],
SELECT(Facility[Facility],
AND(
([Spots Available] > 0), IN([Facility], Virtual Queue[Facility]))
))

1 Like