Need Help in sum basis filter of a column

[Anonymous]

Hi Team,

Please help me, actually i need the sum of a column basis some filter on another column.

in below table i need to calculate/show only sum basis 2021 i.e 2900

Column1  Column2

2021        2323

2021        2878

2020        2374

2019        8256

2021        0022

Thank you

[ERD · Accepted solution]

GHi @Anonymous ,

You'll need something like this:

Measure = SUMX ( FILTER ( T, T[Column1] = 2021 ), T[Column2] )

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