Optimizing performance: Tables or measures?

HI PaulDBrown,

>>I have a suspicion that the reason behind the delay is that a number of the measures use the SUMMARIZE function. And I was wondering if it might not be much more effecient actually to create tables using SUMMARIZE instead of using the function in the measure itself.

As you said, if you have lots of measures need to create variable summary table to calculate, it will spend more resource than use summarize function to create static calculated table.

In addition, if you use some functions who has filter as their parameters(e.g. sumx, countx...), please not use complex expression or add loop check of other tables in expression position.

BTW, power bi will stored data model in local SSAS instance, you can also use SSAS monitor to check its performance.

CONNECT TO POWER BI DESKTOP MODEL FROM EXCEL AND SSMS

Regards,

Xiaoxin Sheng