Measure Killer Measure Killer

How do I find and safely remove unused measures and columns from a semantic model?

Scan the model with Measure Killer: rows in red are used nowhere in the reports, measures or other consumers in scope. Then remove them with a clean TMDL export, or with the 1-click cleanup over XMLA for models in the Service.

Last updated · November 21, 2026

Steps

  1. For a file: open it in Power BI Desktop and pick Single model and report (details). For a shared model in the Service: pick Shared model online so every report on the model counts (details).
  2. Click Analyze. Rows highlighted in red are unused: nothing in the scanned scope references them.
  3. Before you remove anything, make sure the scan covered every consumer: reports in other workspaces, downstream models and Excel files (what counts as unused).
  4. Pick a removal method. A clean TMDL export is the recommended one; the 1-click cleanup works over XMLA for models in the Service (which method?).
  5. Re-scan after the change to confirm nothing broke.
  6. With a license, open Clean your model for the next round: unused DAX variables, Auto Date/Time, hidden pages and more (details).

What you see

Measure Killer scan result with unused columns highlighted in red

Cleaning up the data underneath instead? See Clean up a dataflow and Clean up a Lakehouse, Warehouse or SQL Database.

Go deeper

Something wrong or out of date on this page?

Report an issue with this page

Tell us what is wrong or out of date. No email needed.