cancel
Showing results for
Did you mean:
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!!!

1 ACCEPTED SOLUTION
Super User
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.

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.

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

4 REPLIES 4
Super User
What is the formula for the Calls per Day formula please?

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.

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.

Super User
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.

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.

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!!!

Announcements

#### Power BI September 2023 Update

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

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### 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!

#### 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
Top Kudoed Authors