Manual year filter next to a time-intelligence function
"Manual year filter next to a time-intelligence function" is one of the dax quality checks Auditabi runs on a Power BI semantic model. n expression(s) combine a time-intelligence function with a manual filter on a year or month column. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Pick one approach: time intelligence over the date table, or explicit filters — not both in the same measure.
What is detected
n expression(s) combine a time-intelligence function with a manual filter on a year or month column. The two mechanisms fight for the same filter context and the result depends on their order.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Pick one approach: time intelligence over the date table, or explicit filters — not both in the same measure.
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