Filter results based on another table not directly connected.

[Flambix]

Hello, I have a case and I can't figure out how to deal with it.

I have 3 references tables : 

1. "Calendar"

2. "list of employees" with their number

3. "list of projects" with their number

Our staff is rotating, and their wages are different each month.

I have then 2 facts tables : 
1. "pay" with the wages every month

2. "planning" with the repartition of each employee into their respectiv projects.

planning is connected to the 3 references tables, but pay only to list of employee and calendar. Thus, when I try to dispatch the cost of wages it doesn't distributes wages to the projects. I can't figure out how to build a dax formula to get this... Could someone help me?

Thanks in advance

[lbendlin]

Read about TREATAS. It allows you to project filters from one table to another.