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 pr...
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.

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try a measure like

 

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