Forum Discussion

andi2333's avatar
andi2333
Helper I
1 year ago
Solved

Error with simple DAX query

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
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    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. 

1 Reply

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    1 year ago

    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.