Forum Discussion
Anonymous
2 years agoNot applicable
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?
In short, yes
1 Reply
- MattAllington
Community Champion
In short, yes