Guide Dax Link

| Function | Description | | :--- | :--- | | IF(<condition>, <true>, <false>) | Branching logic | | SWITCH(<expr>, <value1>, <res1>, ...) | Multiple conditions | | ISBLANK() | Checks for BLANK (not zero) | | SELECTEDVALUE(<col>) | Returns value if one filter on column; else BLANK | | HASONEFILTER() / ISCROSSFILTERED() | Inspection of filter context |

Customer Segment = VAR TotalSpend = SUM(Sales[Amount]) RETURN SWITCH( TRUE(), TotalSpend >= 10000, "High Value", TotalSpend >= 1000, "Medium Value", "Low Value" ) guide dax

To get the most out of DAX, follow these best practices and optimization techniques: | Function | Description | | :--- |