cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Calculate Average of measure column

 

Hi!

 

I have created a measure that brings calls per day by dividing Measure Total Calls by Measure Total Business Days. This is working fine, but now i need  way that i can show by region the average of the calls per day instead of the sum! i tried using AVERAGEX, but as you can see below as an example for Greater Midwest i should be getting 4.1 average calls for day instead of 1.92.

 

any help is appreciated!!!

 

ivargaspr_2-1595542809468.png

 

 

ivargaspr_1-1595542777025.png

 

 

ivargaspr_0-1595542611604.png

 

1 ACCEPTED SOLUTION

Try AVERAGEX over the VALUES(Territory) instead of Date. This is because you want average of region based on Territory average, rather than based on Daily average across all territories.

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

View solution in original post

4 REPLIES 4
AllisonKennedy
Super User
Super User

What is the formula for the Calls per Day formula please?

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Anonymous
Not applicable

Hi Allison!

 

Below is a snapshot of the formula. its basically dividing my total calls measure by total business days. I have a table for business days that is connected to my main time table so it can adapt to my time slicer. 

 

 

ivargaspr_0-1595703461906.png

 

Try AVERAGEX over the VALUES(Territory) instead of Date. This is because you want average of region based on Territory average, rather than based on Daily average across all territories.

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Anonymous
Not applicable

This worked!. Thanks so much!!!

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors