Remove duplicate measures
Find & Resolve Identical DAX
Optimize
Overview
Features
Prompts
Troubleshooting
Key Features
Over time, different team members create measures that do the same thing — Total Sales, Sales Total, Sum of Sales, all with identical DAX. Cleaning this up means tracing every reference across visuals, filters, bookmarks, and expressions before you can safely delete anything. This skill finds all duplicates, compares their usage across every dependency, recommends which to keep, and optionally consolidates all references automatically.
How it works
Type /duplicate-measures, point it to your Measure Killer export, and the skill does the analysis:
Loads the Measure Killer JSON and groups measures by normalized DAX expression
Compares usage across all dependency categories — visuals, filters, DAX references, field parameters
Generates a comparison report with keep/retire recommendations
Optionally resolves duplicates by updating all references in your PBIP project
What you get
Analysis report (.md) — executive summary table with keep/retire recommendations per duplicate group
Per-group dependency comparison — side-by-side usage across visuals, filters, DAX, and field parameters
Migration steps — exact list of visuals, measures, filters, and field parameters that need updating
Resolved PBIP (optional) — modified project with all references consolidated
Explore more in this category
No items