Thank you for the response, the measure had no errors itself, but when I put it into a visual it has an error, and this is the error:
Error Message: MdxScript(Model) (40, 16) Calculation error in measure 'Candidate Activity'[In last Month]: 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.
I'm not sure why this is? I shouldn't convert the [active_date] should I?