Solved: Re: Need help in sum basis filter

Anonymous · ‎10-03-2021

Hi Team,

I would need your support in getting the solution for one of my query.

From below tabel i need the sum of total unit only for year 2021.

Need

Fowmy · ‎10-03-2021

@Anonymous

Create a new Measure as follows:

Total 2021 Units = Calculate ( SUM( TableName[Unit]) , TableName[Year] = 2021 )

Did I answer your question? Mark my post as a solution! and hit thumbs up

Fowmy · ‎10-03-2021

@Anonymous

Create a new Measure as follows:

Total 2021 Units = Calculate ( SUM( TableName[Unit]) , TableName[Year] = 2021 )

Did I answer your question? Mark my post as a solution! and hit thumbs up

Need help in sum basis filter