Unused Measures

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:

1. The measure is not referenced in the DAX expression of any other measure.
2. The measure is not bound to any visual in any report connected to this dataset.
3. The measure is not used in any report-level, page-level, or visual-level filter.
4. 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.