Forum Discussion
Creating an average from a measure?
Hi All, I have a measure "CountCalls" - this calculated based on 'COUNTROWS' and tells me how many calls have been recieved. I'm trying to create an average of 'CountCalls' but it's not possi...
I've looked at a few AVERAGEX examples but can't figure out how to use this in practice.
The example of AVERAGEX I've found is...
AVERAGEX(<table>,<expression>
So I'm guessing this translates to...
AVERAGEX(<mycallstable>,<expression>)
But I don't understand what <expression> I would use.
Hi dnewton, in this case <expression> would be your measure CountCalls
I found a good tutorial on this function on this page:
https://powerpivotpro.com/2010/09/averagex-the-5-point-palm-exploding-fxn-technique-revisited/
Also, like jthomson mentioned, you have to think about what you want to average over - do you want daily average? Or monthly? That would determine what the <table> argument should be.