average of column values depending upon the duplicate text entries in another column

[Anonymous]

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

[amitchandak · Accepted solution]

@Anonymous , Simple average should do that ?

Average(Table[Column3])

Or try like

avergageX(summarize(Table, Table[column1], Table[column2], Table[column3]),[column3])

[Anonymous]

thanks amit, you are right. it worked.