Forum Discussion

SteveG_91's avatar
SteveG_91
Icon for Helper I rankHelper I
4 years ago
Solved

Calculating An Average Of A Measure

I have a table named ITC_DAILY_STATS that records one row for each application received.  Our months are divided into one of five categories, named month_code (12WD, 12WE, 3WD, 8WD, 8WE).  I'm trying...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    SteveG_91 , Can try it on month year name

    APP COUNT AVG = AVERAGEX(VALUES('A2055 ITC_BIZ_DATES'[Month Year name]),calculate([APP COUNT]) )

     

    or

     

    APP COUNT AVG = AVERAGEX(summarize('A2055 ITC_BIZ_DATES','A2055 ITC_BIZ_DATES'[Month Year name],[Month Code]),calculate([APP COUNT]) )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

SteveG_91 , Can try it on month year name

APP COUNT AVG = AVERAGEX(VALUES('A2055 ITC_BIZ_DATES'[Month Year name]),calculate([APP COUNT]) )

 

or

 

APP COUNT AVG = AVERAGEX(summarize('A2055 ITC_BIZ_DATES','A2055 ITC_BIZ_DATES'[Month Year name],[Month Code]),calculate([APP COUNT]) )

  • SteveG_91's avatar
    SteveG_91
    Icon for Helper I rankHelper I
    4 years ago

    Thanks amitchandak , your first measure worked, APP COUNT AVG = AVERAGEX(VALUES('A2055 ITC_BIZ_DATES'[Month Year name]),calculate([APP COUNT]) ).

     

    I thought I had used month year name on my first try and it didn't work so I switched to month_code.  I guess I didn't.  Anyway, thanks for your help!