Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Average function giving different result per row

Hi,

 

I'm trying to get an average from a column but is giving a different value every row.

I'm unsure how to find the average for the entire column.

 

The data source is a salesforce report I created with some mock cases.

I've created a new column to calculate the average: 

Average IRT= AVERAGE('Closed cases'[Initial response business hours])
 
Output:

 

Anyone have an idea how to get one value for the entire column?

 

Thanks!

  • Anonymous's avatar
    Anonymous
    6 years ago

    I've found the solution. 

    The problem was with how the report was being generated not with the formula.

     

     

6 Replies

  • mussaenda's avatar
    mussaenda
    Community Champion
    Hi Anonymous ,
    You may want to try this:
    Average IRT= CALCULATE(AVERAGE('Closed cases'[Initial response business hours]), ALL('Closed cases'))
    • Anonymous's avatar
      Anonymous
      Not applicable

      mussaenda Thanks for the quick reply. Unfortunately it gives the same result as before.

      • mussaenda's avatar
        mussaenda
        Community Champion

        Strange. Are there any data on your visual from different table?