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] )
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])

 

smpa01's avatar
smpa01
Community Champion
4 years ago

Anonymous  what is 

'Measures (2)'
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Just a table I have my Measures in

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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