Getting Sum instead of Average

[Anonymous]

Hello,

I thought I had a measure that captures the Average YTD from the previous year.  But, it only looked right last month because it was the first month of the year.

When I refreshed the data for February, I realized that it was summing instead of getting the average.

The actuals for the previous year were: 83,172 (Jan) and 81,911 (Feb).  But instead of getting an average of  82,541, I am getting the total of 165,083.

Here is the measure I created:

SunPrintHD Prior Year = IF(AND(Hyperionstatsdata[category_] = "n_SubscriptionPrintOnly_SundayAvg - Subscription Print Only - Sunday Avg",

Hyperionstatsdata[version] = "Actual"),

CALCULATE(AVERAGE(Hyperionstatsdata[Actual]), 

SAMEPERIODLASTYEAR(Hyperionstatsdata[drawdateme]),

FILTER(ALL(Hyperionstatsdata),Hyperionstatsdata[category_] = "n_SubscriptionPrintOnly_SundayAvg - Subscription Print Only - Sunday Avg"),

FILTER(ALL(Hyperionstatsdata),Hyperionstatsdata[version] = "Actual")), 0)

I am getting the correct figures isolated, but not sure why it is summing instead of getting the average?

Any help would be much appreciated.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523