Forum Discussion

Pillic's avatar
Pillic
Icon for Helper II rankHelper II
4 years ago
Solved

ADD calculated Average to each row

Hello comunity,   I have a simple table that looks like this: delivery | product | price | r price       1011084259  10096246  37 50,7 1011085643  10096246  37 44,1 1011260543  10...
Need Help
  • Barthel's avatar
    Barthel
    4 years ago

    Hey,

     

    Try this:

    r price + average = 
VAR r_price =
    SUM ( 'table'[r price] )
VAR r_price_average =
    CALCULATE ( AVERAGE ( 'table'[r price] ), ALLSELECTED () )
RETURN
    r_price + r_price_average
Barthel's avatar
Barthel
Icon for Solution Sage rankSolution Sage
4 years ago

Hey,

 

Try this:

r price + average = 
VAR r_price =
    SUM ( 'table'[r price] )
VAR r_price_average =
    CALCULATE ( AVERAGE ( 'table'[r price] ), ALLSELECTED () )
RETURN
    r_price + r_price_average
Pillic's avatar
Pillic
Icon for Helper II rankHelper II
4 years ago

Hello Barthel,

 

amazing that did the job. I needed to change it a bit like this:

r price + average = 
VAR r_price =
    SUM ( 'table'[r price] )
VAR price_average =
    CALCULATE ( AVERAGE ( 'table'[price] ), ALLSELECTED () )
RETURN
    r_price + r_price_average

 

Thanks a ton for this fast response...Yall have a nice weekend, as I will now.