Solved: Need Help in sum basis filter of a column

Anonymous · ‎10-02-2021

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 · ‎10-02-2021

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.

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

Check out my latest demo report in the data story gallery.

Stand with Ukraine!

Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!

View solution in original post

ERD · ‎10-02-2021

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.

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

Check out my latest demo report in the data story gallery.

Stand with Ukraine!

Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!

Need Help in sum basis filter of a column

Helpful resources

Fabric certifications survey

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024