Sum of max values per product

[Anonymous]

Hello, guys, hope you're doing well. 

I am having struggle trying to solve a problem, let me explain it. 

So there is 3 columns, Cod Produto (represents product code), Nr Sequencia (Sequence Number) and Qtd Total

I have a measure that brings me the value of qtd total of highest sequence number, or, the last sequence. 

STK =

VAR STOK = MAX('fEstoque Lancamento'[Nr Sequencia])

RETURN CALCULATE(

                 VALUES('fEstoque Lancamento'[Qtd Total]),

                 'fEstoque Lancamento'[Nr Sequencia] = STOK

)



So, my next challenge is to sum the  Qtd total of all products only for the highest sequence number for each individual product.

As you can see above, I have the value of the last sequence for each product, but the problem is that the measure only brings the real last sequence product value, that is 3.743,12. And what I need is to sum the value of the last sequence of all the products. 

[Wilson_ · Accepted solution]

Hi thatjoey20,

Try this in a new measure:

SUMX (
    VALUES ( 'fEstoque Lancamento'[Cod Produto] ),
    [STK]
)

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.