Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
need some help on calculating avg of values depending upon text duplicates rows in another 2 columns
i have a table fetched via api
i am trying to create a measure/column that can generate avg depending upon duplicate text rows in another columns so that overall rows can be reduced.
for example -
Column 1 Column 2 Column3
A CT 0.22
A CT 0.34
B CT 0.23
B TR 0.11
B TR 0.14
C ED 0.25
C TR 0.14
im looking for below output
Column1 Column2 Column2
A CT avg of(0.22,0.34)
B CT 0.23
B TR avg of(0.11,0.14)
and so on
Solved! Go to Solution.
@Anonymous , Simple average should do that ?
Average(Table[Column3])
Or try like
avergageX(summarize(Table, Table[column1], Table[column2], Table[column3]),[column3])
@Anonymous , Simple average should do that ?
Average(Table[Column3])
Or try like
avergageX(summarize(Table, Table[column1], Table[column2], Table[column3]),[column3])
thanks amit, you are right. it worked.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |