Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
SteveG_91
Helper I
Helper I

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 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).
 
SteveG_91_0-1655927512552.png

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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]) )

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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]) )

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!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.