AverageX vs Summarize Field by Average in Pivot Table?

jbaich

Board Regular
Joined
Nov 2, 2011
Messages
140
Hey everyone, pretty new to DAX here so still trying to learn, but I'm curious why I'm getting different results when I use an AVERAGEX function vs the the built-in Summarize as Average function in my pivot table?

The source data table looks like this:

1719254513412.png


You'll notice that some of the entries don't have time reported. I don't want those to be included in the average. Ie. i don't want it to be dividing 183 WFs Completed by 7.5 hrs, it should be 29/7.5...

I created the following Pivot table with one values column just summarizing the Units Completed/Hr as an Average and another values column where I tried to create a measure using AVERAGEX. As you can see I'm getting different values between the two and just trying to understand why and which one is more accurate. This is my AVERAGEX measure: =AVERAGEX(VALUES('Table1'[Task Completed Date]),'Table1'[WFs Completed/Hr])
This is what my Pivot Table is looking like:

1719254169227.png


The light blue column headers are the AverageX measure values and the orange column headers are the built in Summarize as Average values. They match on the row context, but the Grand Totals are different at 4.10 and 3.80 and I'm not sure why?

Thanks,
Joe
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Forum statistics

Threads
1,224,890
Messages
6,181,612
Members
453,057
Latest member
LE102024

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top