Unused Measures
Detects measures that are not referenced by any other measure or any report visual.
What It Detects
This flag identifies DAX measures in a semantic model that are not:
- Referenced by any other DAX measure expression
- Used in any report visual, matrix, card, or chart
- Used in any filter, slicer, or conditional formatting rule
- Referenced in any KPI definition
Why It Matters
- Clutter — Unused measures increase the size of the field list, making it harder for report authors to find what they need.
- Maintenance risk — Developers may unknowingly update or depend on unused measures, wasting effort.
- Misleading documentation — Unused measures can suggest functionality that does not actually appear in any report, confusing new team members.
Trigger Conditions
A measure is flagged as unused when all of the following are true:
- The measure is not referenced in the DAX expression of any other measure.
- The measure is not bound to any visual in any report connected to this dataset.
- The measure is not used in any report-level, page-level, or visual-level filter.
- The measure is not referenced in a KPI definition.
Threshold: Zero references across all criteria.
Output
| Field | Description |
|---|---|
measureName | Name of the unused measure |
tableName | Home table of the measure |
expression | The DAX expression (truncated to 200 chars) |
datasetName | Semantic model name |
workspaceName | Workspace name |
Notes and Edge Cases
- Measures used in paginated reports or Excel connections — The scanner may not detect usage in paginated reports (RDL) or external Excel live connections. If a measure is used only in those contexts, it may be falsely flagged. Verify before deleting.
- Display folder measures — Measures organized into display folders are scanned the same way; the folder structure does not affect flagging.
Related Flags
- Unused Columns — Same concept applied to columns.
- Duplicate Measures — Measures with identical DAX that may indicate one copy is unused.