Revenue in max date

Shinyl Try:

Measure =
  VAR __MaxDate = MAXX(ALL(Revenue[RecordDate]),Revenue[RecordDate]))
  VAR __Result = SUMX( FILTER( ALLEXCEPT('Revenue', [Customer]), [RecordDate] = __MaxDate ), [Value] )
RETURN
  __Result

Hi,

PBI file attached.

Hope this helps.