DAX filter with data

[Marcin]

Hi,

 I have table with users where is column named "First Contract Date" , some are empty, type Date. 

I need make calculation with another table "Events"  where is hours time measure bo using only users with First Contract Date earlier than today. 

I made this 

CALCULATE( [Working Days]*8 - ([Days Vacation]+[Days Vacation S]+[Days Sick])*8 - [Hours Projects] - [Hours Sales], FILTER(Users, Users[First Contract Date] < NOW()))

Unfortunately I is not working, shows Hours for all users without filtering. 

[v-huizhn-msft]

Hi @Marcin,

If there is relationship between your two tables?  'all users without filtering' means that the FILTER written in DAX didn't affect your measure? Could you please share more details or sample table as @vanessafvg said? So that we can post the solution which is close to your requirements.

Thanks,
Angelia

[vanessafvg]

@Marcin

can you give some examples of the data with teh firstcontractdate, your new column

is this all in one table?