Forum Discussion
Optimizing a measure filter with calculated table
Super UserAnonymous , both filter, and calculatetable is going to generate a table as output that will filter. Unless calculatetable add a value I doubt there is need to use it. Also you are using the calculate table on the master table that will be limited one table, create on fact that will allow you to filter all master table inside one calculatetable.
Hi Amit,
I was trying to replace Filter with Calculatetable for optimizing my measure basis the following article:
https://www.sqlbi.com/articles/filter-vs-calculatetable-optimization-using-cardinality-estimation/#
As my fact table is huge and this measure extrapolates it on my Date table for all dates within the selected range. Plus it does a lookup on my GL Master table which is also large compared to other masters.