Error with simple DAX query

[andi2333]

Hello, I am not sure whats going wrong here since this seems a very simple topic.

I have an excel table with approx 7000 entries showing log errors on a daily basis, so e.g.

Date | Error

01.08.2024 | Error 1

01.08.2024 | Error 2

02.08.2024 | Error 1

02.08.2024 | Error 3

etc.

Now I want to simply calculate how many errors I have on the last date entered in that file.

My query: 

VAR_LogErrorsLastDay = CALCULATE(COUNT('LogErrors'[Error),FILTER('LogErrors', MAX('LogErrors'[Date])))

However, this query only returns me the count of ALL of my entries in the excel, and not narrowed to the last date.

Am I missing something?

Thanks

[rajendraongole1 · Accepted solution]

Hi @andi2333 -Your DAX query is almost correct, but the issue lies in how you're trying to filter the data to only count errors on the last date

please use the below 

VAR_LastDate = MAX('LogErrors'[Date])
VAR_LogErrorsLastDay = CALCULATE(
COUNT('LogErrors'[Error]),
'LogErrors'[Date] = VAR_LastDate
)
RETURN VAR_LogErrorsLastDay

Hope it works.