Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Pinherio
Frequent Visitor

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

try this

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

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

AVERAGE(Data[Measure 3])

this does not work 

Helpful resources

Announcements
ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.