Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi @anettbaksa
try AVERAGEX() function, like
Measure = CALCULATE(AVERAGEX(Table, Table[YourMaxMeasure]))
Refer to
https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013
you need to do Avg of Max
Hi @anettbaksa
try AVERAGEX() function, like
Measure = CALCULATE(AVERAGEX(Table, Table[YourMaxMeasure]))
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |