Quick answer
DAX CALCULATE not filtering: How to Fix It usually happens because the formula, source data, formatting, or calculation settings do not match what the workbook needs. Start by testing the issue on one simple row before changing the whole file.
What it usually means
The workbook is giving you a warning sign. The fastest fix is to separate the problem into four checks: formula syntax, referenced cells, data type, and workbook settings.
Likely causes
- The measure may be evaluated in an unexpected filter context.
- Relationships between tables may be missing, inactive, or many-to-many.
- The measure may return blank because the denominator or filtered table is empty.
Step-by-step fix
- Check the visual filters, page filters, and slicers.
- Confirm relationships in the model view.
- Use a simple test measure to confirm the base numbers.
- Use DIVIDE instead of / when a denominator may be blank or zero.
Useful check formula
Test Measure = DIVIDE([Numerator], [Denominator], 0)How to prevent it next time
- Use Excel Tables so ranges expand consistently.
- Keep helper columns visible while testing a new formula.
- Document important assumptions directly in the workbook.
- Use IFERROR only after you understand the real cause of the error.