How to Convert the date column to text and Integer column to Text when using filters in DAX?

[manjarigoyal]

I want to count the total number of sites where Aging is greater than 90 days and Sliped date is NOT BLANK. The data type of Sliped Date is DATE and Aging is INTEGER type. I tried to use the formula below but I am getting the error "MdxScript(Model) (30, 195) Calculation error in measure 'CSR Swap Request Status'[> 90 Days]: DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values."

90 Days =

CALCULATE(COUNTA('CSR Swap Request Status'[Site ID]),FILTER('CSR Swap Request Status',FORMAT('CSR Swap Request Status'[Sliped Date],"mm/dd/yyyy") <> ""), FILTER('CSR Swap Request Status',FORMAT('CSR Swap Request Status'[Aging] > 90,"General Number")))

[amitchandak]

@manjarigoyal , Try like

90 Days =
CALCULATE(COUNTA('CSR Swap Request Status'[Site ID]),FILTER('CSR Swap Request Status', not(isblank('CSR Swap Request Status'[Sliped Date])) && 'CSR Swap Request Status'[Aging] > 90))

[manjarigoyal]

@amitchandak I am still getting the same error

[amitchandak · Accepted solution]

@manjarigoyal , I doubt Aging is int or whole number then , try this

90 Days =
CALCULATE(COUNTA('CSR Swap Request Status'[Site ID]),FILTER('CSR Swap Request Status', not(isblank('CSR Swap Request Status'[Sliped Date])) && 'CSR Swap Request Status'[Aging] > "90"))

Can you share  a sample pbix after removing sensitive data.