ISERROR Function (DAX)

Checks whether a value is an error, and returns TRUE or FALSE.

This article describes a function in Data Analysis Expressions (DAX), a formula expression language used to define calculations in Power Pivot in Excel. Many DAX functions have the same name and similar behavior as Excel functions; however, DAX functions can only be used in DAX formulas.

In this article


Syntax

ISERROR(<value>)

Top of Page Top of Page

Parameters

Term

Definition

value

The value you want to test.

Top of Page Top of Page

Return Value

A Boolean value of TRUE if the value is an error; otherwise FALSE.

Top of Page Top of Page

Example

The following example calculates the ratio of total Internet sales to total reseller sales. The ISERROR function is used to check for errors, such as division by zero. If there is an error a blank is returned, otherwise the ratio is returned.

= IF( ISERROR(
SUM('ResellerSales_USD'[SalesAmount_USD])
/SUM('InternetSales_USD'[SalesAmount_USD])
)
, BLANK()
, SUM('ResellerSales_USD'[SalesAmount_USD])
/SUM('InternetSales_USD'[SalesAmount_USD])
)

Top of Page Top of Page

 
 
Applies to:
Excel 2013, Power Pivot in Excel 2013