Scenario: Calculate the average score.
Notice how they handle the "Absent" student differently.
Ready...
💻 DAX Formula
-- Scenario 1: Standard Average
MEASURE Avg Score = AVERAGE( Scores[Points] )
-- Ignores text. Denominator = 2
-- Scenario 2: Average All (Includes Text)
MEASURE AvgA Score = AVERAGEA( Scores[Points] )
-- Text counts as 0. Denominator = 3