I have found myself in many situations in which I have wished that the following was possible:
[_THISROW].[Reference column].[Column from referenced table]
Without the above, I have to create a separate column for the dereference first before being able to use it in a selection formula like this: [_THISROW].[Created Dereference Column].