Calculating average

Hi , Thank you for reaching out to the Microsoft Community Forum.

Please try this:
EvalDesignM =
VAR Admin =
AVERAGEX(
FILTER(
crb87_consultantevaluation,
crb87_consultantevaluation[crb87_proactivelyensuredunderstandingoftasksd] > 0 &&
crb87_consultantevaluation[crb87_invoicesandprogressreportswereproperlyd] > 0 &&
crb87_consultantevaluation[crb87_respondedtothecountyinatimelyd] > 0
),
DIVIDE(
crb87_consultantevaluation[crb87_proactivelyensuredunderstandingoftasksd] +
crb87_consultantevaluation[crb87_invoicesandprogressreportswereproperlyd] +
crb87_consultantevaluation[crb87_respondedtothecountyinatimelyd],
3
)
)
VAR Resources =
AVERAGEX(
FILTER(
crb87_consultantevaluation,
crb87_consultantevaluation[crb87_providedeffectivesolutionstoidentifiedd] > 0 &&
crb87_consultantevaluation[crb87_effectivelymanagedresourcesincludingsubd] > 0 &&
crb87_consultantevaluation[crb87_effectivelyfacilitatedpermittingactivitiesde] > 0 &&
crb87_consultantevaluation[crb87_effectivelyparticipatedinutilitycoordinationd] > 0
),
DIVIDE(
crb87_consultantevaluation[crb87_providedeffectivesolutionstoidentifiedd] +
crb87_consultantevaluation[crb87_effectivelymanagedresourcesincludingsubd] +
crb87_consultantevaluation[crb87_effectivelyfacilitatedpermittingactivitiesde] +
crb87_consultantevaluation[crb87_effectivelyparticipatedinutilitycoordinationd],
4
)
)
VAR Communication =
AVERAGEX(
FILTER(
crb87_consultantevaluation,
crb87_consultantevaluation[crb87_scheduledconductedanddocumentedd] > 0 &&
crb87_consultantevaluation[crb87_communicatedanynecessarydesignd] > 0 &&
crb87_consultantevaluation[crb87_effectivelytrackedandmonitoredd] > 0
),
DIVIDE(
crb87_consultantevaluation[crb87_scheduledconductedanddocumentedd] +
crb87_consultantevaluation[crb87_communicatedanynecessarydesignd] +
crb87_consultantevaluation[crb87_effectivelytrackedandmonitoredd],
3
)
)
VAR Execution =
AVERAGEX(
FILTER(
crb87_consultantevaluation,
crb87_consultantevaluation[crb87_effectivelymanagedthebudgetd] > 0 &&
crb87_consultantevaluation[crb87_designsweredoneinaccordanced] > 0 &&
crb87_consultantevaluation[crb87_successfullymetthescoped] > 0
),
DIVIDE(
crb87_consultantevaluation[crb87_effectivelymanagedthebudgetd] +
crb87_consultantevaluation[crb87_designsweredoneinaccordanced] +
crb87_consultantevaluation[crb87_successfullymetthescoped],
3
)
)
RETURN
(Admin * 0.2 + Resources * 0.25 + Communication * 0.25 + Execution * 0.3) * 0.25

*some changes maybe needed

If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.