Sum a measure

[Anonymous]

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

[parry2k · Accepted solution]

@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 · Accepted solution]

Thanks a lot, worked perfectly

[parry2k]

@Anonymousglad to help. You marked your own reply as a solution . FYI

[parry2k · Accepted solution]

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

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