March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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
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
User | Count |
---|---|
120 | |
78 | |
58 | |
52 | |
46 |
User | Count |
---|---|
170 | |
117 | |
63 | |
58 | |
51 |