Forum Discussion

Michalison's avatar
Michalison
Helper II
4 years ago
Solved

Calculation error in measure

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

Need Help
  • AUaero's avatar
    AUaero
    4 years ago

    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)
	)
)



4 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    4 years ago

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

    • Michalison's avatar
      Michalison
      Helper II
      4 years ago

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

       

  • AUaero's avatar
    AUaero
    Responsive Resident
    4 years ago

    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)
	)
)