Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
hi, @6mon
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |