How to sum multiple latest values based on timestamp column which have the same opp nº?

[antoniosantos]

Hello!

The measure below does get the latest of each and that works when I place it into a table visual, but not on a card. It only plots the last value found, instead of summing the latest of each opportunity.

TotalR$Oportunidade =

VAR _max =

MAXX (

    FILTER (

        ALLSELECTED ( BDOportunidades ),

            BDOportunidades[Nº da Op.] = MAX ( BDOportunidades[Nº da Op.] )

        ),

    BDOportunidades[Timestamp]

)

RETURN

CALCULATE (

    SUM ( BDOportunidades[Total R$]), BDOportunidades[Timestamp] = _max

)

Appreciate your help!

[amitchandak · Accepted solution]

@antoniosantos , hope these two can help

Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...