Forum Discussion

Helper II

8 years ago

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...

Resolver V

8 years ago

Hi dnewton, you might want to try AVERAGEX - the iterator version of AVERAGE

dnewton
Helper II
8 years ago
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.
- DAX0110
  Resolver V
  8 years ago
  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.
- pawel1
  Kudo Kingpin
  8 years ago
  try this:
  
  averageX Count Calls monthly =
  AVERAGEX (
  ALLSELECTED ( 'Date'[Month]) , [CountCalls] )
  
  averageX Count Calls weekly =
  AVERAGEX (
  ALLSELECTED ( 'Date'[Week]) , [CountCalls] )