Measures stored on a fact table
"Measures stored on a fact table" is one of the maintainability checks Auditabi runs on a Power BI semantic model. n measure(s) live on a fact table. It is a hygiene note: provable, worth fixing, but it never moves the health score. Keep measures in one or more dedicated measure tables, grouped by subject in display folders.
What is detected
n measure(s) live on a fact table. Report authors then find measures mixed with columns, and the field list order depends on the table rather than on the business subject.
Why it matters
Hygiene and conventions. Reported in its own section and never deducted from the health score.
How to fix it
Keep measures in one or more dedicated measure tables, grouped by subject in display folders.
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