Forum Discussion

efeltri's avatar
efeltri
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 i...
  • TomMartens's avatar
    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

     

TomMartens's avatar
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's avatar
    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's avatar
    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)