Reply
Pinherio
Frequent Visitor
Partially syndicated - Outbound

average of a measurement

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... 

 

Pinherio_0-1709976273644.png

 

2 REPLIES 2
Uniqueusername
Helper II
Helper II

Syndicated - Outbound

try this

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

Syndicated - Outbound

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

AVERAGE(Data[Measure 3])

this does not work 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)