Convert Implicit measures to Explicit
Explicit DAX from Aggregations
Overview
Features
Prompts
Help
Key Features
Someone drags a column into a visual, Power BI quietly makes a "Sum of Revenue", and the chart looks fine — but that aggregation isn't a real measure. You can't reuse it, no other measure can reference it, and it doesn't follow your naming or formatting. Worse, on a busy report those implicit aggregations hide everywhere: field wells, sort-by settings, conditional formatting, filter conditions. Hunting them all down and swapping each for a proper measure by hand is slow and easy to get wrong. This skill scans the page, shows you exactly what it found and the measures it plans to create, and — only once you say go — swaps every reference in place, reusing a matching measure when you already have one instead of making a duplicate — run it with /convert-implicit-measures.
How it works
Type /convert-implicit-measures, point it to the target page, and the skill runs a three-step workflow:
Scan — discovers every implicit aggregation on the page and checks whether an equivalent explicit measure already exists in your model
Ask — shows you the planned conversions and asks whether to reuse matching existing measures or always generate new ones
Execute — replaces aggregations in field wells, sort definitions, conditional formatting, and filter conditions; inserts new measures into your TMDL; validates zero aggregations remain
What you get
Converted visuals — all
visual.jsonfiles updated in place with explicit measure referencesNew TMDL measures — inserted into your measure table with proper DAX and lineage tags
Optional conversion log (.md) — every change listed with visual ID, field, aggregation type, and measure name
Explore more in this category
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


