Goal: Calculate total deviation from the target.
Problem: Positives (+20) and Negatives (-20) cancel each other out to 0.
Ready...
💻 DAX Formula
-- Scenario 1: Standard Subtraction
MEASURE Variance = Sales - Target
-- Result can be negative. Summing them might result in 0.
-- Scenario 2: Absolute Deviation
MEASURE Abs_Var =
ABS( Sales - Target )
-- Converts negative numbers to positive.