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 c...
Need Help
  • 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.

     

     

mussaenda's avatar
mussaenda
Community Champion
6 years ago
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
    6 years ago

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

    • mussaenda's avatar
      mussaenda
      Community Champion
      6 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago
        mussaenda wrote:

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

        Just one table is used in this visual.