关于sum与时间智能函数的性能

// DAX Query
DEFINE
    ---- MODEL MEASURES BEGIN ----
    MEASURE 'FACT'[xx1] =
        CALCULATE (
            SUM ( 'FACT'[offtake_value] ),
            'FACT'[offtake_value] <> 0
        )
        
        
    MEASURE 'FACT'[xx2] =
        SUM ( 'FACT'[offtake_value] )
        
        
    MEASURE 'FACT'[xx3] =
        CALCULATE (
            SUM ( 'FACT'[offtake_value] ),
            DATEADD ( 'Dim Calendar'[Date], -1, YEAR )
        )
        
        
        
    MEASURE 'FACT'[xx4] =
        VAR d =
            MAX ( 'Dim Calendar'[Date] )
        RETURN
            CALCULATE (
                SUM ( 'FACT'[offtake_value] ),
                KEEPFILTERS ( 'Dim Calendar'[Date] = EDATE ( d, -12 ) )
            )
            
    MEASURE 'FACT'[xx5] =
        VAR d =
            MAX ( 'Dim Calendar'[Date] )
        VAR dd =
            DATE ( YEAR ( d ) - 1, MONTH ( d ), DAY ( d ) )
        RETURN
            CALCULATE (
                SUM ( 'FACT'[offtake_value] ),
                KEEPFILTERS ( 'Dim Calendar'[Date] = d )
            )
    ---- MODEL MEASURES END ----
    VAR __DS0Core =
        SUMMARIZECOLUMNS (
            ROLLUPADDISSUBTOTAL ( 'Dim Store'[banner_name_en], "IsGrandTotalRowTotal" ),
            "All_UPI_", 'FACT'[xx5]
        )
    VAR __DS0PrimaryWindowed =
        TOPN (
            502,
            __DS0Core,
            [IsGrandTotalRowTotal], 0,
            'Dim Store'[banner_name_en], 1
        )
EVALUATE
__DS0PrimaryWindowed
ORDER BY
    [IsGrandTotalRowTotal] DESC,
    'Dim Store'[banner_name_en]

求去年单天DATEADD ( 'Dim Calendar'[Date], -1, YEAR )明显最慢