Forum Discussion

Marcin's avatar
Marcin
Helper V
9 years ago

DAX filter with data

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. 

Need Help

2 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago

    Marcin

     

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

     

    is this all in one table?

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    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