IFERROR Error

[Anonymous]

I am getting an error "Argument '2' in IFERROR function is required.

% of Stores with void =

IF(

    HASONEVALUE(DTRData[Item]),

        IFERROR(DIVIDE(

            SUM('DTRData'[Void Count]),

                [Total Store Count],0),

        IFERROR(DIVIDE(

            SUM('DTRData'[Void Count]),

                AVERAGEX(DTRData,[All Items All Stores Selling]),0),

)))

Any thoughts for correcting?

[grantsamborn]

Hi @Anonymous 

The second argument isn't optional.

IFERROR - DAX Guide

[Anonymous]

@grantsamborn 

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

[grantsamborn]

Hi @Anonymous 

Because DIVIDE captures *almost* all possible errors, I'm wondering why you even need IFERROR (or ISERROR).

IF you need IFERROR for some reason, the following hopefully shows what you need.

% 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.
    )
)

If you want an example of ISERROR, let me know.

Grant

[grantsamborn]

Are you sure you don't mean ISERROR?

ISERROR - DAX Guide

[grantsamborn]

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