- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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]) )
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
Online Event
Register Here
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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]) )
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
Online Event
Register Here
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Subject | Author | Posted | |
---|---|---|---|
07-25-2024 10:54 AM | |||
01-23-2024 10:48 AM | |||
Anonymous
| 03-07-2024 08:14 AM | ||
06-13-2024 04:11 AM | |||
04-19-2024 05:45 PM |
User | Count |
---|---|
105 | |
75 | |
44 | |
39 | |
33 |
User | Count |
---|---|
165 | |
90 | |
65 | |
46 | |
43 |