I don't know if it's the best solution, but I eventually stumbled on a working filter for my problem:

filter({[Pay Elements Trans].[Pay From Date].[Pay From Date].members * [Employee].[Date Hired].[Date Hired].members}, [Pay...