Forum Discussion
Performance issue - matrix parallel calculation
I have this matrix that presents 5 measures.
Each of those take between 1.5 and 5 seconds to crunch if presented each in their own matrix.
When put together, it seem PBI can't do the calculation in parallel but rather one after the other. Bottom line the 5 measures matrix takes 15+ seconds to render.
Besides optimizing the model, is there something to be done?
Doesn't make sense to me those calculations are done in sequence...
The data source is a tabular model reached using live connection.
1 Reply
hi, Anonymous
I think some measures are invoke other measures who contains specific filter and calculations.
For these measures, they will caused to filters conflict and looping calculation.(current row count * invoke measures calculation amount)
Optimizing the mode or Dax is the main method for this
Some reference links:
Optimizing DAX expressions involving multiple measures.
Best Regards,
Lin
