Measure not calculating all rows

[Anonymous]

Hello everyone,

I have following measures that are supposed to calculate the maxDate and the currentDate of LASTMODIFIED

maxDate is calculated with reference to TC_ID because there is sometimes multiple results for one ID

and I only want the latest one.

CurrentResult =

var currentDate = CALCULATE(MAXX(RESULT,RESULT[LASTMODIFIED]))

return currentDate

LatestResult =

var MaxDate = CALCULATE(MAXX(RESULT,RESULT[LASTMODIFIED]),

ALLEXCEPT(RESULT,RESULT[TC_ID]))

return MaxDate

This results in the following table. Where LatestResult is absolutely fine I wonder why CurrentResult is not giving a result for all rows...

Can anybody please help me with this?

[Anonymous · Accepted solution]

Figured that one out by doing this:

CurrentResult =
var currentDate = CALCULATE(MAXX(RESULT,RESULT[LASTMODIFIED]),

ALLEXCEPT(RESULT,RESULT[LASTMODIFIED]))
return currentDate