Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculated measures average

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

  • Hi Anonymous 

    try AVERAGEX() function, like

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