Forum Discussion
Optimizing performance: Tables or measures?
Hello everyone! I am hoping for some advice as to how to improve performance in a model I'm building. The dataset is actually small: a main fact table with under 5K rows, a couple more fact table...
HI PaulDBrown,
After finish looking at your description, I think your formula will cause the performance issue.
I found some measures are invoke multiple 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)
Some reference links:
Optimizing DAX expressions involving multiple measures.
Normally, I often use simple calculated measures in other measure.(e.g, sum, max, average or static value...)
They can work as original calculation formula and work with current filter effect without any performance issue.
Regards,
Xiaoxin Sheng
