DAX Efficiency - SUMX and IF Statement

[Anonymous]

I am looking to improve the performance of a DAX measure that I am using in a report.  Is there a better way to filter to only evaluate on rows where CY TTM Production <> 0 than how I am doing it?

The measure is:

SUMX ( tblDim_Account,

IF (

ROUND ( [CY TTM Production], 2 ) = 0,

0,

( ( [CY TTM WIP] - [TTM Change in Reserve] ) + ( ( [CY TTM Production] - ( [CY TTM WIP] ) ) * [CY TTM Billed Realization] ) )

)

)

[tamerj1 · Accepted solution]

Hi @Anonymous 

please try

=
SUMX (
    tblDim_Account,
    VAR CYTTMProduction = [CY TTM Production]
    VAR CYTTMWIP = [CY TTM WIP]
    RETURN
        IF (
            ROUND ( CYTTMProduction, 2 ) = 0,
            0,
            ( ( CYTTMWIP - [TTM Change in Reserve] ) + ( ( CYTTMProduction - ( CYTTMWIP ) ) * [CY TTM Billed Realization] ) )
        )
)