Forum Discussion

Vinnie's avatar
Vinnie
Icon for Helper I rankHelper 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...
Vinnie's avatar
Vinnie
Icon for Helper I rankHelper I
2 years ago

Hi Anonymous , thanks for you reply. It does proces a lot of rows. Millions. 

 

We have a Pro license so I don't think that the workspace is assigned to Premium capacity? Is it still possible to optimize the query itself with some easy tricks?