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

[Anonymous]

Hi All,

need some help on calculating avg of values depending upon duplicates in another 2 columns

i have a table fetched via api . now the table has multiple columns 

i am trying to create a measure/column that can remove the duplicacy and generate avg 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

[v-xulin-mstf · Accepted solution]

Hi @Anonymous,

Try measure as:

Measure =

CALCULATE(

   AVERAGE('Table'[Column3]),

   FILTER(

       ALL('Table'),

       'Table'[Column2]=MAX('Table'[Column2])&& 'Table'[Column1]=MAX('Table'[Column1])

   )

)

 Here is the output:

Here is the demo, please try it: average of column values depending upon the duplicate entries in another column

Best Regards

Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.