Convert Implicit measures to Explicit
Explicit DAX from Aggregations
Overview
Features
Prompts
Help
Key Features
Someone dragged a column into a visual and Power BI created a "Sum of Revenue" aggregation. Implicit measures can't be reused or referenced by other measures, and a report with 50 visuals might have aggregations scattered across field wells, sort definitions, conditional formatting, and filter conditions. This skill scans your project, shows you exactly what it found and what it plans to create, then — after your confirmation — converts every reference in place — 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)
129 USD
Category
Optimize
Version
Version 2.1.1.2.15
or log in if you already have an account


