Forum Discussion

Vinnie's avatar
Vinnie
Helper I
2 years ago

Optimize DAX query

Hi all,   I am trying to optimize the following DAX query:   CALCULATE( SUMX( SUMMARIZECOLUMNS( 'Loan balance history'[source loan part id], "AverageOutstandi...
sjoerdvn's avatar
sjoerdvn
Solution Sage
2 years ago

does it perform better if you rewrite your measure like below?

CALCULATE(
    SUMX(
        VALUES('Loan balance history'[source loan part id]),
        CALCULATE(AVERAGE('Loan balance history'[outstanding amount]))
        )
     ),
    USERELATIONSHIP(Calender[Date], 'Loan balance history'[Date])
)