Forum Discussion
Solved
Average
Hi, I have to do the average in the "delivery cost column", without sum the quantity. For example. where in "n° extra shipping" column there is "0" i want to have an average like 0€ where there i...
Hey,
try a measure like thisan average = AVERAGEX( VALUES('table'[N° Extra Shipping] ,CALCULATE(AVERAGE('table'[delivery cost]) )Hopefully this will provide what you are looking for.
Regards,
Tom
Hey,
try a measure like this
an average =
AVERAGEX(
VALUES('table'[N° Extra Shipping]
,CALCULATE(AVERAGE('table'[delivery cost])
)
Hopefully this will provide what you are looking for.
Regards,
Tom
Thank you for our answer.
But im facing this problem. It dont me let add "calculate". What is the problem?
"N° trasporti extra" is "N° extra shippping", and "costo trasporto" is "delivery cost"