Hello, I am working on " Understanding how variables are evaluated" in Mastering DAX Calculations course. In this video Sam explain if we add ALL function around Dates table ( ALL(Dates)) result would not change even we change the filter context using date column.
Customer Sales of Top Products = CALCULATE ( [Total Sales], FILTER ( Products, CALCULATE ( [Total Sales], ALL ( Dates ) ) > 100000 )
But if we change the date ( by date column as a filter) it is changing. Can someone explain what is happening in this calculation.