Forum Discussion
Solved
Average Calculation With Filter
Hi Wonder if anyone can help. I have a set of results. Basically column A has a list of people, Column B has a list of test names and Column C has a list of scores. I am trying to write a...
Allselected is not the right function.
AverageAllTestname = CALCULATE(AVERAGE(Result[Score]),ALL(Result))AverageByTestname = CALCULATE(AVERAGE(Result[Score]),ALLEXCEPT(Result,Result[Test Name]))
Paul,
Best
Allselected is not the right function.
AverageAllTestname = CALCULATE(AVERAGE(Result[Score]),ALL(Result))
AverageByTestname = CALCULATE(AVERAGE(Result[Score]),ALLEXCEPT(Result,Result[Test Name]))
Paul,
Best