Remove duplicated measures
Find & Resolve Identical DAX
Overview
Features
Prompts
Help
Key Features
Over time, different team members create measures that do the same thing — identical DAX expressions living under different names across multiple tables. Cleaning this up requires tracing every reference across visuals, filters, and expressions before safely deleting anything. This skill reads your PBIP project directly, finds all duplicates, generates a timestamped report before touching anything, then walks through each group interactively so you choose what to keep — run it with /duplicate-measures.
How it works
Type /duplicate-measures, point it to your PBIP project, and the skill handles everything:
Scans all TMDL table files, extracts every measure, and normalizes DAX for comparison
Counts visual and DAX references per measure from the PBIP report JSON files
Generates a timestamped customer-facing report with keep/retire recommendations — before any changes are made
Asks per-group which measure to keep (or skip the group entirely)
Applies retirement in-place and verifies all groups are resolved
What you get
Analysis report (.md) — executive summary table with keep/retire recommendations per duplicate group
Per-group comparison — visual reference counts, DAX references, table location side by side
Per-measure detail — visual IDs, referencing measure names, and issues list (wrong table, naming inconsistencies)
Migration steps — exact list of visuals, TMDL expressions, and culture file entries that need updating
Applied changes — TMDL and visual.json updated in-place after your per-group confirmation
Tool Information
Skill
39 USD
Bundle (All skills)
129 USD
Category
Optimize
Version
Version 2.1.1.2.15
or log in if you already have an account


