IFERROR Error

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