Not Understanding Why AVERAGEX Is Not Averaging

DAX DAX Calculations
1

Hi,
Please find attached my PBIX file.
Test Sales.pbix (107.0 KB)

I created simple sales scenario to explain my issue. It contains three sales orders for the same date and for two customers. I’ve defined four measures as shown in the report. The problem I am having is that the AverageX does not always seem to average when it should.

If you notice in the visual Measures by Customer, the Avg Sales seems to calculate properly, but the Avg Sales (Values Date) and Avg Sales (Values Customer ID) are the same as Total Sales. I am not new to context, but I cannot seem to grasp why at least the Avg Sales (Values Customer ID) isn’t return the same value as Avg Sales.

I know the simple answer is just use the Avg Sales. However, I have seen training here in Enterprise DNA and it shows the form with VALUES() and I like to know why things work they way they work. Thanks for any help on this. Best Regards, Jim

2

@SignupNow

Values returns a singe column table of unique values.

image

Hope this clarifies

3

Thanks, Rajesh. That does help. I can see now the average of those one-line items will return the summed amount. Thanks, Jim

4

@SignupNow

Welcome. Yes because of unique values, sum and average are same.