why averagex works with measure but with the same code it does not?

[Anonymous]

Why is it that this works:

Avg Months Rev:=

AVERAGEX(VALUES('Date'[Month Year]),

[Measure])

(the measure is Measure:= calculate (sum(table[column)))

But this doesnt, even though it is the same code:

Avg Months Rev:=

AVERAGEX(VALUES('Date'[Month Year]),

sum(table[column])

[Anonymous · Accepted solution]

Hi @Anonymous ,

You may take a look at this blog about how to choose sum, sumx and calculate 

https://p3adaptive.com/2014/10/sum-sumx-or-calculatechoices-choices/ 

What a SUM does is it will SUM the values to give you a total.

What CALCULATE will do is give you the ability to change the filter context of your measure.

Calculate(sum(table[column])) and sum(table[column]) have different filter context in your formula.

You could modify the second formula as below:

Avg Months Rev:=

AVERAGEX(VALUES('Date'[Month Year]),

CALCULATE(sum(table[column]))

Best Regards,

Jay

[amitchandak]

@Anonymous , in  row level function you need to use calculate

Avg Months Rev:=

AVERAGEX(VALUES('Date'[Month Year]),

calculate(sum(table[column])))

If you are not using measure with values then need to use calculate