Microsoft Power BI Data Analyst Practice Question

Inside CALCULATE, ALL('Product') discards every filter that originates from any column in the Product table. ALL('Date') removes every filter from the Date table, ensuring the result is not affected by Year, Month, or other date slicers. The boolean filter YEAR('Date'[Date]) = YEAR(TODAY()) then reapplies the current-year condition. Because CALCULATE applies filters in sequence, ALL('Date') clears the table first and the predicate adds back only the rows for the current calendar year. The other expressions either leave some Product filters in place or fail to remove existing Date filters, so they do not always return the correct value.