Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

Create measure using average

Hi there,

I am trying to create a measure that averages a measure I currently use.

Existing

SUM('LH_Warranty'[Rebate Value]) + [PartsMarginExVAT]

How would I get the average of the above?

Anonymous does this work?

measure =
AVERAGEX ( ADDCOLUMNS ( tbl, "test", [existingMeasure] ), [test] )

7 Replies

smpa01
Community Champion
4 years ago
Anonymous does this work?

measure = AVERAGEX ( ADDCOLUMNS ( tbl, "test", [existingMeasure] ), [test] )
- Anonymous
  Not applicable
  4 years ago
  Hi smpa01 I've tried but returns blanks
  AVERAGEX(ADDCOLUMNS('Measures (2)',"Margin Average",[Total Margin]), [Margin Average])
  - smpa01
    Community Champion
    4 years ago
    Anonymous what is
    
    'Measures (2)'
- Anonymous
  Not applicable
  4 years ago
  Hi smpa01 I've tried but returns blanks
  AVERAGEX(ADDCOLUMNS('Measures (2)',"Margin Average",[Total Margin]), [Margin Average])
vanessafvg
Community Champion
4 years ago

avg of measure =
AVERAGEX (
LH_Warranty,
LH_Warranty[Rebate Value] + LH_Warranty[other column Value]
)