Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

average of a measurement
03-09-2024
01:25 AM
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
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-09-2024
02:43 AM

try this
Measure =
var Measure3 = AVERAGE(Data[Measure 3])
return AVERAGEX (
VALUEs(Data[Name]),
Measure3
)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-09-2024
03:57 AM

"measure 3" is not a column, it is a measurement.
AVERAGE(Data[Measure 3])
this does not work

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
12-17-2024 03:59 AM | |||
02-07-2024 11:22 AM | |||
01-30-2025 10:09 PM | |||
09-19-2024 11:49 PM | |||
07-18-2016 09:33 AM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
121 | |
105 | |
84 | |
52 | |
46 |