IFERROR Error

Question

I am getting an error "Argument '2' in IFERROR function is required.&nbsp;&nbsp;% of Stores with void = IF(&nbsp; &nbsp; HASONEVALUE(DTRData[Item]),&nbsp; &nbsp; &nbsp; &nbsp; IFERROR(DIVIDE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUM('DTRData'[Void Count]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Total Store Count],0),&nbsp; &nbsp; &nbsp; &nbsp; IFERROR(DIVIDE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUM('DTRData'[Void Count]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AVERAGEX(DTRData,[All Items All Stores Selling]),0),&nbsp; &nbsp; )))&nbsp;Any thoughts for correcting?

grantsamborn · Answer

Hi&nbsp;Anonymous&nbsp;The second argument isn't optional.IFERROR - DAX Guide&nbsp;

anonymous · Answer

grantsamborn&nbsp;&nbsp;I know that but I am not sure what 2nd argument to list as I thought I had built the formula correctly.

grantsamborn · Answer

If the first argument would raise an error, it is replaced by the second argument.

grantsamborn · Answer

Are you sure you don't mean ISERROR?ISERROR - DAX Guide

grantsamborn · Answer

Hi&nbsp;Anonymous&nbsp;Because DIVIDE captures *almost* all possible errors, I'm wondering why you even need IFERROR (or ISERROR).&nbsp;IF you need IFERROR for some reason, the following hopefully shows what you need.&nbsp;% of Stores with void =
IF(
    HASONEVALUE( DTRData[Item] ),
    IFERROR(
        DIVIDE(
            SUM( 'DTRData'[Void Count] ),
            [Total Store Count],
            0
        ),
        ???     // Replace this with the expression you want calculated when the above expression would raise an error.
    ),
    IFERROR(
        DIVIDE(
            SUM( 'DTRData'[Void Count] ),
            AVERAGEX(
                DTRData,
                [All Items All Stores Selling]
            ),
            0
        ),
        ???     // Replace this with the expression you want calculated when the above expression would raise an error.
    )
)&nbsp;&nbsp;If you want an example of ISERROR, let me know.Grant

Forum Discussion

IFERROR Error

5 Replies

Related content

IFERROR

IFERROR in DQ

iferror in M Language

IFERROR Problem

Using LOOKUPVALUE in IFERROR producing an error