Remove duplicated measures

Find & Resolve Identical DAX

Optimize

Optimize

duplicate-measures

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:

  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)

129 USD

Category

Optimize

Version

Version 2.1.1.2.15

or log in if you already have an account