Forum Discussion

New Member

7 years ago

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 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

N° Extra shipping	Means of delivery	delivery cost €
0	CAMION	- €
0	CAMION	- €
0	CAMION	- €
1	FURGONE1	5,00 €
1	FURGONE1	5,00 €
1	FURGONE1	5,00 €
2	FURGONE2	10,00 €
2	FURGONE2	10,00 €

TomMartens
7 years ago
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

3 Replies

TomMartens
Super User
7 years ago
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
- efeltri
  New Member
  7 years ago
  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"
- efeltri
  New Member
  7 years ago
  ok, i have correct the formula, but it isnt what i have to do.
  My result it should be:
  A=10€
  A=10€
  A=10€
  
  TOTAL= 10€
  
  B=5€
  B=5€
  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)