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
Hi KSASSESSMENT
try
Average of Score total for Score =
CALCULATE(AVERAGE('Results'[Score]); ALLEXCEPT('Results';'Results'[Test Name]))ALLSELECTED removes filter from column
ALLEXCEPT removes filters from other column
do not hesitate to give a kudo to useful posts and mark solutions as solution