Ignore same values from different dates

[pamelasantosf]

Hi!
I need to calculate the total Volume, ignoring repeated Volume values in the same Id.
Maybe something like create a conditional, where if the Volume in that row is equal to the Volume in the previous Rank_update, it's equals 0, and if it's differente, show the value.

Any help will be highly appreciated!

id	last_update	rank_update	volume
101	26/05/2021 13:51:25	4	6700
101	21/05/2021 17:30:29	3	6700
101	20/05/2021 21:31:28	2	6700
101	03/09/2020 17:15:39	1	8630

[v-henryk-mstf · Accepted solution]

Hi @pamelasantosf ,

I did a test and tried the following measure:

Measure 2 = 
var _table=SUMMARIZE(ALL('Table'),[id],[volume])
return
SUMX(_table,[volume])

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@pamelasantosf , Try a measure like

sumx(summarize(Table, Table[ID], Table[Volume]),[Volume])