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.
try this:
averageX Count Calls monthly =
AVERAGEX (
ALLSELECTED ( 'Date'[Month]) , [CountCalls] )
averageX Count Calls weekly =
AVERAGEX (
ALLSELECTED ( 'Date'[Week]) , [CountCalls] )