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 to calculate the average number of apps received each month, grouped by the month_code. In other words, what is the average number of apps received in the 12WD months, in the 12WE months, etc. I have a slicer so the user can select one of the month_codes.
I have this measure to count the number of apps received, which works fine
App Count = count('ITC_DAILY_STATS'[APP_NUM])
Following other posts on here I wrote this measure to calculate the average of the 'App Count' measure
APP COUNT AVG = AVERAGEX(VALUES('A2055 ITC_BIZ_DATES'[Month Code]),'Calculations'[APP COUNT])
However, when I display the APP COUNT AVG in a card visual it gives me the total of all the months in that month_code rather than the average. In this example below, the total is 147,276 but what I want is the average of that (36,819).