Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Averaging Not Working Correctly

I am trying to display 'impressions' by week, alongside the Average impressions by station for all weeks.  The average works for some stations (highlighted yellow), but not all (red).  What am I missing in my measure?

 

Gross_Impressions_AverageByStation = CALCULATE(
AVERAGE(Media[Gross_Impressions]),
ALLEXCEPT(Media,Media[Station_Code])
)

 

 

 

Need Help

5 Replies

    • parry2k's avatar
      parry2k
      Super User
      8 years ago

      Can you double check if your table is sorted by station_code and there are not rows somewhere else in the table. I noticed in the image that there is scroll bar and there might be more rows for that station_code

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Average should be the sum of the 4 rows divided by 4 (149809).  I included a measure for SUM and that is off too.  It should be 599236 but shows >3million.  The data is sorted by station_code and BroadCast_Week.