Summarize killing performance

[airwolf39]

Hi Folks,

My measure is causing my visual to take 90 seconds to load. The issue is with summarizing the data. If i change the false statement of "hasonefilter' to 'test', it is very fast.

But when i include the summarize code, the performance takes a huge hit:

Any help would be appreciated.

[Anonymous · Accepted solution]

Hi @airwolf39 ,

Maybe you can use SELECTCOLUMNS instead of SUMMARIZE and use ISINSCOPE instead of HASONEFILTER.

The efficiency of your measure is not only dependent on the dax formula you use, it's also be decided by the model structure(e.g.: columns/rows number, relationship) 

In addtion, I would suggest you use the tools "performance analyze" in power bi. This tool will show you the underlying dax function, you can know how complex your measure is. 

You can also refer to the doc and blog below to improve your model.

https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance

https://www.sqlbi.com/articles/introducing-the-power-bi-performance-analyzer/

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

This would be a good time to open up DAX Studio and have a look at the query plan for that measure. Specifically watch out for excessive looping.  You have lots of nested measures too - the recommendation is to avoid that if possible.