DAX Average

[JNM]

I need some help on how to create a measure that does the average of 5 year columns shown. Each of the columns are separate measures. As shown in the picture the AverageTtlSales value isn't the average of the 5 years - it shows 10, I want it to be 168.

The AverageTtlSales measure is:

=Average([SalesQty])

I tried:

=Average(sum([SalesQty]))

The AVERAGE function only accepts a column reference as an argument.

I also tried:

=Average([TTl SalesQty])

Calculation error in measure 'MeppsILE'[AverageTtlSales]: The AVERAGE function only accepts a column reference as the argument number 1.

Thanks for the help...

 

[JNM]

It didn't upload my picture so here it is in a layout

Item Year1 Year2 Year3 Year4 Year5 TtlYr AvgYr
AB0 460 232 122 92 9 915 10

 

[JNM]

Got it!

=Averagex(VALUES('Date Value'[FYrTxt]),[TTl SalesQty])

 

[JNM]

And the result is 183, not 165 - fat fingered the calculator...