Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Performance - High Resource Usage - CALCULATE with SUMMARIZE

Cheers guys.   I am using something like:   MEASURE = CALCULATE ( SUM ( 'TABLE1'[COLUMN1] ); FILTER ( SUMMARIZE ( ALL ( 'TABLE1'[ID]; ...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi svalen ,

     

    Summarize() will take much calculation of DAX engine. How many rows and columns are there in your data source.  In addtion, there is 1GB data size limitation in power bi so pleae check if your data size is too large.

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi svalen ,

 

Summarize() will take much calculation of DAX engine. How many rows and columns are there in your data source.  In addtion, there is 1GB data size limitation in power bi so pleae check if your data size is too large.

 

Regards,

Jimmy Tao

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi again v-yuta-msft

 

Like 5M rows.

 

In the meantime, I think this has to do with the fact that I added a second ID on the visual that isn't in the SUMMARIZE and it just can't calculate.

 

Different measure, but related with the other post we are discussing:

 

http://community.powerbi.com/t5/Desktop/Context-on-Measure-with-Summarize/m-p/464113#M215397

 

I didn't add the second ID on the SUMMARIZE because I couldn't solve the aggregation issue, similar to what we are discussing on the other post.

 

I will mark this as solved, thanks.