This article describes how to implement a syntax equivalent to the T-SQL function NULLIF and the ANSI SQL function COALESCE, in DAX. As do many languages, D| www.sqlbi.com
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE.| dax.guide
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE. Uses eager execution plan.| dax.guide