Forum Discussion
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...
I've found the solution.
The problem was with how the report was being generated not with the formula.
Hi Anonymous ,
You may want to try this:
Average IRT= CALCULATE(AVERAGE('Closed cases'[Initial response business hours]), ALL('Closed cases'))mussaenda Thanks for the quick reply. Unfortunately it gives the same result as before.