Handling errors with other DAX functions

As with any programming language, coding DAX calculations will inevitably result in an error being generated. While error handling in DAX is perhaps not quite as mature and robust as some other programming languages, DAX does provide some basic capabilities for handling errors within DAX code. A certain, limited number of DAX functions include internal error checking, and this recipe demonstrates using the built-in error checking provided by these special DAX functions.

Getting ready

To prepare for this recipe, perform the following steps:

1. Open Power BI Desktop.
2. Use an Enter Data query to create a table called R02_Table with the following data:

Color	Value
Red	0
Green...