Solved: Average

efeltri · ‎09-14-2018

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 is 1, 5€ and where there is 2 , 10€. Even if filter for "means of delivery" or date.

I hope i was clear.

Could you please help me?

Thank you

TomMartens · ‎09-14-2018

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

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

TomMartens · ‎09-14-2018

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

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

efeltri · ‎09-27-2018

ok, i have correct the formula, but it isnt what i have to do.

My result it should be:

A=10€

TOTAL= 10€

B=5€

TOTAL=5€

GRAND TOTAL= 15€

Now my resul is 10+10+10+5+5+5 =45€ (with the formula like a coloumn)

and 10+10+10=30 5+5+5=15 /2 =22.5 (with the formula like a measure)

efeltri · ‎09-27-2018

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"

Average