Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need help in sum basis filter

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 

  • Anonymous 

    Create a new Measure as follows:

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

1 Reply

  • Anonymous 

    Create a new Measure as follows:

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