Max Date

[ooctaviano]

I need help, I'm having issues with a measure, I have a table like this

I need a measure that brings me the last date with accidents, in this case 3/28/2021, and also the previous date with accidents.

I have this measure but for some reason it does not bring any date back

Last Date = calculate(MAX(RA[Date]),filter(RA,RA[Accidents]>0))

Also tried

Last Date = CALCULATE(MAX( RA[Date] ),FILTER( ALL( RA ), RA[Acidents] > 0 ))

but also does not work

It may be something with the filtres.

Please advise I need help

[amitchandak · Accepted solution]

@ooctaviano , Try a measure like

MAXX(filter(allselected(RA),RA[Accidents]>0),RA[Date])

[ooctaviano]

I just needed to use all instead of allselected

Thanks a lot for the help

[ooctaviano]

Same issue, still not showing the last date.