average of a measurement

[Anonymous]

Hello, 

I have the table below, measure 1 and measure 2 are calculated from columns. measure 3 is the percentage difference between them.

I want to create a new table with only "Name" col and the average of of measurement 3. 

example: for "AA" the average is (60 + 12 + 50) / 3 = 41

Thanks in advance 

https://docs.google.com/spreadsheets/d/1yDRjc1srQRyoGOkXsubrSJfWDGLtP9U9/edit?usp=sharing&ouid=11016... 

[Uniqueusername]

try this

Measure = 
var Measure3 = AVERAGE(Data[Measure 3])
return AVERAGEX (
    VALUEs(Data[Name]),
   Measure3
    
)

[Anonymous]

"measure 3" is not a column, it is a measurement. 

AVERAGE(Data[Measure 3])

this does not work