Hi,

I have to calculate the average of averages.

I used the following measures:

PalletsTotaal =

COUNTROWS(FactInslag)

PalletsGemiddeld =

AVERAGEX(VALUES(DimDatum[Date]); [PalletsTotaal] )

AantalDagenGedraaid =

COUNTX(VALUES(FactInslag[Datum]); FactInslag[Datum])

So basically the measure that computes the average of PalletsGemiddeld must be one value