Calculation error in measure

[Michalison]

I am trying to do a measure that filters employees who resigned and leaving date > 01/01/2021

Count Resignations = CALCULATE(COUNT(Personnel_Records[Resignation]),FILTER('Personnel_Records','Personnel_Records'[Resignation]="1" && (Personnel_Records[Leaving Date]>"01/01/2021"))

When I do this I get the follwing error

Calculation error in measure 'Calculation'[Count Resignations]: DAX comparison operations do not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.

Can anyone help me on this as I don't know the correc

[AUaero · Accepted solution]

Maybe just a copy/paste error, but your calculation is missing a closing parentheses.  What is the data type of Personnel_Records[Resignation]?  If it's not a string then there's no need to enclose the 1 in double quotes.  You can also try passing the date to the [Leaving Date] explicitly as a date.

CALCULATE(
	COUNT(Personnel_Records[Resignation]),
	FILTER(
		'Personnel_Records',
		'Personnel_Records'[Resignation] = 1 && 
		'Personnel_Records'[Leaving Date] > DATE(2021, 1, 1)
	)
)

[Michalison]

Many thanks that worked perfectly

[HotChilli]

Quotes ("").  Comparisons need to be done on the same datatype

[Michalison]

How do I do this? - sorry teaching myself PoeerBI as I go along