DAX average score

Hi AnthNC ,

Thanks for the reply from belvoir99 , please allow me to provide another insight: 

You can change the expression for ScoreBelvoir99 to

ScoreBelvoir99 =
VAR SumMark = SUM(Marks[weighted mark])
VAR SumMaxMark = SUM(Marks[max weighted mark])
VAR SumMarkAllShops =
CALCULATE(
SUM(Marks[weighted mark]),
REMOVEFILTERS(Marks[shop])
)
VAR SumMaxMarkAllShops =
CALCULATE(
SUM(Marks[max weighted mark]),
REMOVEFILTERS(Marks[shop])
)
RETURN
IF(ISINSCOPE(Marks[subitem]),
DIVIDE(
SumMark.
SumMaxMark
), IF
IF(ISINSCOPE(Marks[evaluated item]) && SELECTEDVALUE(Marks[country])="Country 1" && SELECTEDVALUE(Marks[evaluated item])="Phone skills",
DIVIDE(
SumMarkAllShops,
SumMaxMarkAllShops
), DIVIDE(
DIVIDE(
SumMark, SumMaxMarkAllShops ), DIVIDE(
SumMaxMark
)
)
)

You can also change Score3 to

Score3 =
VAR SumMark = SUM(Marks[weighted mark])
VAR SumMaxMark = SUM(Marks[max weighted mark])
VAR SumMarkAllShops =
CALCULATE(
SUM(Marks[weighted mark]),
REMOVEFILTERS(Marks[shop])
)
VAR SumMaxMarkAllShops =
CALCULATE(
SUM(Marks[max weighted mark]),
REMOVEFILTERS(Marks[shop]))
VAR IsScopeSpecific = SELECTEDVALUE(Marks[country])="Country 1" && SELECTEDVALUE(Marks[evaluated item])="Phone skills" && NOT ISINSCOPE(Marks [subitem])
RETURN
IF(IsScopeSpecific.
DIVIDE(SumMarkAllShops, SumMaxMarkAllShops, SumMarkAllShops)
SumMaxMarkAllShops
),
DIVIDE(
SumMark, SumMaxMarkAllShops ), DIVIDE(
SumMaxMark
)
)

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.