問題文
An analyst wants a category label with multiple conditions: "High" if sales exceed 1000, "Medium" if between 500 and 1000, otherwise "Low". Which construct handles multiple ordered conditions cleanly?
選択肢
- A bin on the Sales measure.
- CASE [Sales] WHEN > 1000 THEN "High" END
- IF ... THEN ... ELSEIF ... THEN ... ELSE ... END, testing the conditions in order.
- Three separate calculated fields combined with SUM, one per band, so the totals resolve into a single label per row.