Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Ignore same values from different dates

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!

 

idlast_updaterank_updatevolume

101

26/05/2021 13:51:2546700
10121/05/2021 17:30:2936700
10120/05/2021 21:31:2826700
10103/09/2020 17:15:3918630
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi Anonymous ,

     

    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.

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Try a measure like

     

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

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    5 years ago

    Hi Anonymous ,

     

    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.