Goal: Map numeric codes to text labels.
SWITCH moves line-by-line until it finds a match.
Ready...
💻 DAX Formula
-- Scenario 1: Exact Value Match
MEASURE Label = SWITCH( Priority[Code],
1, "High", -- Case 1
2, "Medium", -- Case 2
3, "Low", -- Case 3
"Unknown" -- Else
)
-- Scenario 2: SWITCH TRUE (Advanced Logic)
SWITCH( TRUE(),
[Code] = 1, "Critical",
[Code] <= 3, "Normal",
"Review" )