Forum Discussion
Summarize killing performance
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.
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.