Case

Case(cond1, r1, cond2, r2, … [, default]) · Logic & variables

Multi-branch searched conditional (SQL CASE WHEN … THEN …): conditions are evaluated in order and the first true one wins; the optional trailing default catches the rest (omitted ⇒ blank). All results must share one type. This replaces the DAX SWITCH(TRUE(), …) idiom directly.

Example

RevenueTier := Case(
    [Revenue] >= 1000000, "Tier 1",
    [Revenue] >= 100000,  "Tier 2",
    "Tier 3")

Good to know

Conditions compare measure-level values. Branching on a bare column (Case(Sales.Segment = "SMB", …) at the top level) is row logic — a calculated field (SQX014).