Calculated measures average

[anettbaksa]

Hello Everybody, 

I have a table filling with sales data. 

I have to calculate the max value in every month and after I have to calculate the avarege of this max values. 

I can do the monthly max value, but after I get stuck because de avarage function is working only with column not with calculated measures. 

Can anybody help me? 

Thanks a lot, 

Anett

[amitchandak]

Refer to

https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013

you need to do Avg of Max

[az38 · Accepted solution]

Hi @anettbaksa 

try AVERAGEX() function, like

Measure = CALCULATE(AVERAGEX(Table, Table[YourMaxMeasure]))