Expression condition to include field from a different table

[MauriceWhelan]

Hi. I have the following expression as an initial value to pull the MAX time that exists in the table. MAX(SELECT(Works_Orders_Master[Production Finish Time],[Date of Production]=[_THISROW].[Date of Production])

Is there anyway that I can incorporate fields called [Department] & [Area] from an associated table called (Routings_Master) - associated through [Record ID] as Ref type.

Something like
MAX(SELECT(Works_Orders_Master[Production Finish Time],AND([Date of Production]=[_THISROW].[Date of Production],
Routings_Master[Department]=[_THISROW].[Department],Routings_Master[Area]=[_THISROW].[Area])))

Hope that makes sense.

Many thanks.

Maurice.