Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sum a measure

date          A        B 201601     200     20 201602      300    10 201701      500     50 201702      100     10 Have already created a measure  sum(a)/sum(b) which gives me  201601     10 2...
Need Help
Show and Tell
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous you need to add year column in your table and then use folloing measure

     

    Avg Sum = SUMX( VALUES( Table[Year] ), <your average measure>)
  • Anonymous's avatar
    Anonymous
    7 years ago

    Thanks a lot, worked perfectly

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous you need to add year column in your table and then use folloing measure

 

Avg Sum = SUMX( VALUES( Table[Year] ), <your average measure>)