Optimizing Measure performance (open incidents running total)

Hi Thogen ,

Thanks for the reply from lbendlin .

Your current requirement is that your measure can achieve the function, but the performance is too poor when there are 15,000 data. You are considering how to optimize the performance. Is my understanding correct?

I suggest you consider the following aspects:

1. When the data set is large, the complex Measure syntax will significantly affect the calculation performance. If possible, consider breaking down the measure into simpler intermediate measures.

2. Check the data model to see if it can be optimized. For example, delete unused columns, ensure that the column data type is correct, and possibly summarize the data at a higher level before importing the data into Power BI.

For more detailed guidance, please see:

Optimization guide for Power BI - Power BI | Microsoft Learn

Reasons why your Power BI report is slow & how to optimize | Performance Tuning | MiTutorials (youtube.com)

3. If the database you are using supports the view function, please process the data in the database first, so that Power BI only needs to query the summary table without performing complex calculations on millions of rows.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!