Logical functions

DAX logical functions make a result conditional. IF(condition, if true, if false) returns BLANK if the condition is false and the third argument is omitted. SWITCH(TRUE(), …) replaces nested IFs by testing the conditions in order, the first true one winning.

Example

Niveau = SWITCH(TRUE(), [CA] > 1000, "High", [CA] > 500, "Medium", "Low")

Related concepts

The whole glossary