Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Is ALL Function in the FILTER more optimized for performance?

1. Quantity Sold>3 = CALCULATE( [Customer Sales], FILTER(ALL('Sales by Store'[quantity_sold]),'Sales by Store'[quantity_sold]>3))
2. Quantity Sold>3 = CALCULATE( [Customer Sales], FILTER('Sales by Store', 'Sales by Store'[quantity_sold]>3))

Which one the above DAX code is more optimized for performance?

Isn't option #1 more optimized for performance as it is only scanning the column Quantity sold and not the whole Sales by Store column?