Forum Discussion
AlexaderMilland
Helper III
Helper IIIEfficient rolling total measure
I've created a functional rolling total measure to add to my matrix table. It is however very inefficient, takes extremely long to compute and often requires more than 1GB RAM limit you encounter on ...
m3tr01d
Continued Contributor
Continued Contributorhi AlexaderMilland
I think there are two things that impact the performance of your measures :
1) You are filtering a table in both Filter statement. Filtering a table is really expensive when done on a huge fact table
If you look at some of the videos from SQLBI, its the first thing that they will explain to you is avoid filtering table, always filter a column instead.
2) Second thing is you are not using your calendar table. ISOWEEK should be an attribute of your calendar and you should filter the column ISOWEEK from your calendar table and not the one from the Fact table. Iterating on a column of a dimension will be faster.
You can also remove any columns in the OrderLines table as they take space and impact comprehension of each columns.