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 
  • Fowmy's avatar
    4 years ago

    Anonymous 

    Create a new Measure as follows:

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