Get the count of overdue dates

[JKoivu]

Let's say I have this type of data:

I would like to get the count of events where the date is overdue. Let's assume that today's date is 2020-11-10, and all dates older than 10 days are considered overdue, so in this example that would be only vehicle #2. I have tried a measure like this:

Overdue count =
VAR maxDate = CALCULATE(
  MAX(Events[date]),
  ALLEXCEPT(Events, Events[event_id])
)

RETURN COUNTROWS(
  FILTER(
    Events,
    Events[date] = maxDate && DATEDIFF(maxDate, NOW(), DAY) > 10
  )
)

 But it doesn't seem to show the proper value, instead it's blank.

[amitchandak · Accepted solution]

@JKoivu , Try a measure like 

countx(filter(summarize(Table, Table[event_id], "_1", count(Table[event_id]), "_2", calculate(count(Table[event_id]), filter(Table, Table[Date]<today()-10))), [_1]<> [_2]),[event_id])

[JKoivu]

Thank you @amitchandak this really helped me! Though I had to change the [_1]<>[_2] to [_1] = [_2] in my case.