Forum Discussion
Anonymous
6 years agoNot applicable
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]))
2 Replies
- az38Community Champion
Hi Anonymous
try AVERAGEX() function, like
Measure = CALCULATE(AVERAGEX(Table, Table[YourMaxMeasure])) - amitchandakSuper User
Refer to
https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013
you need to do Avg of Max