Forum Discussion

Anonymous's avatar
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...
Need Help
  • smpa01's avatar
    smpa01
    4 years ago

    Anonymous  does this work?

    measure =
AVERAGEX ( ADDCOLUMNS ( tbl, "test", [existingMeasure] ), [test] )
smpa01's avatar
smpa01
Community Champion
4 years ago

Anonymous  does this work?

measure =
AVERAGEX ( ADDCOLUMNS ( tbl, "test", [existingMeasure] ), [test] )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi smpa01  I've tried but returns blanks

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