Forum Discussion
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
201602 30
201701 10
201702 10,
Now need to sum up this over a year so that i get result like:
2016 40
2017 20
Anonymous you need to add year column in your table and then use folloing measure
Avg Sum = SUMX( VALUES( Table[Year] ), <your average measure>)
