Forum Discussion

ClementSendra's avatar
ClementSendra
New Member
7 years ago
Solved

averageif

Hello,   I try to integrate a column in a table which would calculate an average depending on the value in a column. I know that it is possible to use a formula like :    CALCULATE ( AVERAGE ( '...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi ClementSendra

    Can you show with an example what you need?  A small table with sample data and the required result.

    I don't understand what you mean by

    ... i don't want to precise a specific value like ( "X"), but compare the value of each row.

     

    Maybe this:

    NewColumn =
CALCULATE (
    AVERAGE ( 'table'[column2] ),
    FILTER ( 'table', 'table'[column1] = EARLIER ( 'table'[column1] ) )
)
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Drag Column1 to the Table visual and write this measure

 

=AVERAGE('table'[column2])

j-mag's avatar
j-mag
Frequent Visitor
7 years ago

Hello,

 

How do you get this to work in a table with 10+ columns of data? Given all the columns it doesn't average, just shows the result matching the column I need the average for.

 

Regards,

James