Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measure not calculating all rows

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?

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Figured that one out by doing this:

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

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

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Figured that one out by doing this:

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

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