FILTER(ALL(table)) removes every filter on that table
"FILTER(ALL(table)) removes every filter on that table" is one of the dax quality checks Auditabi runs on a Power BI semantic model. n expression(s) rebuild a period with FILTER(ALL(DateTable), …). It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Prefer DATEADD / SAMEPERIODLASTYEAR / DATESINPERIOD on a marked date table, or restrict ALL to the columns you really need to clear: ALL(Date[Year], Date[Month]).
What is detected
n expression(s) rebuild a period with FILTER(ALL(DateTable), …). This drops slicers on other columns of the same table (fiscal year, week, flags) and is slower than the time-intelligence functions.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Prefer DATEADD / SAMEPERIODLASTYEAR / DATESINPERIOD on a marked date table, or restrict ALL to the columns you really need to clear: ALL(Date[Year], Date[Month]).
Reference
SQLBI: Time intelligence in DAX
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.
More DAX checks
- Arithmetic or comparison on a measure that returns text
- Measure returning text in one branch and a number in another
- Share denominator clears a fact-table column instead of the dimension
- "Previous period" window overlaps the current one
- Percentage label built without ×100
- Percentages and amounts summed together