Forum Discussion

sebasjun's avatar
sebasjun
Icon for Helper I rankHelper I
8 years ago
Solved

SUMX with calculate average

Hello   I need apply this function        I created a simple datatable       AVGx = AVERAGE(Table1[x]) Measure Manual = SUMX(Table1; Table1[x] - 14) Measure Calc = SUMX(Ta...
Need Help
  • OwenAuger's avatar
    OwenAuger
    8 years ago

    Hello sebasjun

    Try this - storing the average in a variable. Previously when the [AVGx] measure was computed in the context of each row, context transition meant that it was just averaging the value on that row.

    Measure Calc =
VAR Avg = [AVGx]
RETURN
  SUMX ( Table1; ( Table1[x] - Avg ) )
  • Stachu's avatar
    Stachu
    8 years ago

    I think the average has to be either with ALL or ALLSELECTED

    AVGx:=CALCULATE(AVERAGE(Table1[x]),ALLSELECTED(Table1[x]))

     

sebasjun's avatar
sebasjun
Icon for Helper I rankHelper I
8 years ago

Hello

 

Thanks for you reply, I try and is 0 

 

I attached the file if you can help me  File

Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
8 years ago

I think the average has to be either with ALL or ALLSELECTED

AVGx:=CALCULATE(AVERAGE(Table1[x]),ALLSELECTED(Table1[x]))

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    This measure gets the same results as your manual process

     

    Measure =
SUM ( Table1[x] ) - CALCULATE ( [AVGx], ALLSELECTED ( Table1 ) )