Calculated column based on filters.

Hey I have the following situation.

I have given a date range from 2010 to 2020.

I want to create the following measure: Count the number of employees if date hired of employees = last date in date table (I created this date table), else 0.

I created the following measure till now:  Measure = CALCULATE(COUNT(Employees[ID]), Filter(Employees, Employees[HireDate]= 'Date Table'[Last Date])

So bascally I want to calculate the count when hire date matches last date, else I want it to return 0. However, it returns weird values even for the year 2019 in the filter. Is there a way in which this can be calculated?

Thank You!

okay i'll try and let u know in a while! Thanks Anonymous@

Anonymous,

What is the last date in date table? Is it a measure? Could you please share sample data of your table and post expected result  based on the sample data?

Regards,
Lydia

Hey, I had posted my sample under a different discussion called "Calculated Column based on Filters" yesterday. There is a detailed description there. Anonymous

Anonymous，

Do you want to get same expected result in the two different discussion? If so, I will merge the  two threads.

Regards,
Lydia

Anonymous Yes, They are related. So I guess you can merge it. Thank You!

Anonymous was my solution the accepted solution???

Anonymous Hey, Sorry. I just tried it and it dint work. However, I have usd tweaking to make it work now.

Hi Anonymous,

Could you please share the solution and mark it as a solution?

Best Regards,

Dale