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...
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