Remove duplicated measures
Find & Resolve Identical DAX
Overview
Features
Prompts
Help
Key Features
On any model a few people have touched, the same calculation ends up written more than once — the same DAX sitting under different names, often on different tables, because nobody knew the other one already existed. Tidying that up by hand is nerve-wracking: before you delete anything you have to chase down every visual, filter, and measure that points at it, or you break a report. This skill reads your PBIP directly, finds every set of duplicates, and writes you a report — before it changes a thing — showing each group, where the measures are used, and which one it suggests keeping (the one used most). Then it walks you through group by group: you pick the keeper, and it rewires every reference and retires the rest for you — 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)
249 USD
Category
Optimize
Version
Version 2.2.2.2
or log in if you already have an account


