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 m...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    try AVERAGEX() function, like

    Measure = CALCULATE(AVERAGEX(Table, Table[YourMaxMeasure]))
az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

try AVERAGEX() function, like

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