Quick answer
Power BI DAX measure returns blank: 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
- Calculation mode may be set to Manual.
- The formula cell may be formatted as Text.
- The referenced cells may be blank, filtered, or not the cells you expected.
Step-by-step fix
- Check Formulas > Calculation Options and choose Automatic.
- Change the cell format to General, then re-enter the formula.
- Use Show Formulas to confirm the formula is written correctly.
- Trace precedents to confirm every referenced cell is correct.
Useful check formula
=IFERROR(B2/C2,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.