If you want the average of a number you’ve already calculated, try using SUMMARIZE to iterate through a virtual table based on those calculations.
For example,
AVERAGEX(
SUMMARIZE ( Dates, QuarterHourColumn,
“Average Results”, PalletsMeasures ),
[Average Results] )
This is the technique I would try first.
For more details see this example below
Here’s the main part to look at
See if this helps
