Remove duplicated measures

Find & Resolve Identical DAX

Optimize

Optimize

duplicate-measures

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:

  1. Scans all TMDL table files, extracts every measure, and normalizes DAX for comparison

  2. Counts visual and DAX references per measure from the PBIP report JSON files

  3. Generates a timestamped customer-facing report with keep/retire recommendations — before any changes are made

  4. Asks per-group which measure to keep (or skip the group entirely)

  5. 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