Today I had a colleague tell me that ALL(Date table[date]), that is – removing the filter from the date column of a date table results in automatic filter removal from all date table columns.
I tried this using a Year slicer, and following measure is displayed in a card visual:
CALCULATE(SUM(SALES[AMT]), ALL(DATETABLE[DATE])
Now when I select the Year in the slicer, then the measure shows me sales in the year. So removing filter over date column of a date table doesn’t result in filter removal from all columns of date table. Is this correct or am I missing something.