Filter dimension in table

[DP_Boy]

I have a table that shows the budget and booked hours of our employees. 

Now I want to filter the employees that stopped working in our company before the selected date.

In the demension I made the following expression:

=if( ALT(EmploymentEnddate,0)=0, EmployeeFullName, if(Min(Year)< Year(EmploymentEnddate), EmployeeFullName))

If I test it in a measure it gives me the correct values but in the demension it gives me an invalid demension. 

How can I solve this problem?

[brunobertels · Accepted solution]

Hi may be this 

aggr(

if( ALT(EmploymentEnddate,0)=0, EmployeeFullName, if(Min(Year)< Year(EmploymentEnddate), EmployeeFullName))

, EmployeeFullName,EmploymentEnddate)

[DP_Boy]

Thanks @brunobertels that works!