Goal: Determine Pass/Fail based on Score & Attendance.
AND (&&): Both must be True.
OR (||): At least one must be True.
Ready...
💻 DAX Formula
-- Scenario 1: Strict (AND)
MEASURE Result = IF(
Score > 50 && Attendance > 80, -- Both must be TRUE
"Pass", "Fail"
)
-- Scenario 2: Flexible (OR)
MEASURE Result = IF(
Score > 50 || Attendance > 80, -- Either one is TRUE
"Pass", "Fail"
)