Create measure using average

[DRossi]

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?

[vanessafvg]

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

[smpa01 · Accepted solution]

@DRossi  does this work?

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

[DRossi]

Hi @smpa01  I've tried but returns blanks

AVERAGEX(ADDCOLUMNS('Measures (2)',"Margin Average",[Total Margin]), [Margin Average])

[DRossi]

Hi @smpa01  I've tried but returns blanks

AVERAGEX(ADDCOLUMNS('Measures (2)',"Margin Average",[Total Margin]), [Margin Average])

[smpa01]

@DRossi  what is 

'Measures (2)'

[DRossi]

Ah apologies, I have amended it to relate to the main table where the data is. Thanks!

[DRossi]

Just a table I have my Measures in