Forum Discussion

ReidiLexi's avatar
ReidiLexi
New Member
3 years ago
Solved

Total on Measure with Max Date not reflecting correctly

I am trying to get the total amount from the latest transaction for all clients. See below for the sample table:   When creating a table in PowerBI, I get the following where the total only r...
  • Ahmedx's avatar
    3 years ago

    write another measure like this
    Fixed = SUMX(VALUES(Sheet1[Client]), [_Latest amount])