Convert Implicit measures to Explicit
Explicit DAX from Aggregations
DAX
Overview
Features
Prompts
Troubleshooting
Key Features
Someone dragged a column into a visual and Power BI created a "Sum of Revenue" aggregation. It works, but implicit measures can't be reused or referenced by other measures. A report with 50 visuals might have aggregations scattered across field wells, sort definitions, conditional formatting, and filters. This skill finds them all, creates proper DAX measures, and replaces every reference — writing changes to a separate folder so your original project stays untouched.
How it works
Type /convert-implicit-measures, configure the project paths, and the skill converts everything:
Scans all visual.json files for Aggregation blocks
Replaces each aggregation with a proper DAX measure reference
Generates TMDL measure definitions with correct naming (e.g.,
Revenue_Sum,Units_Avg)Handles aggregations in field wells, sort definitions, conditional formatting, and filter conditions
Writes changes to a separate output folder
Generates a detailed conversion log
What you get
Converted PBIP — in
models_modified/with all implicit measures replacedConversion log (.md) — every change listed with visual ID, field, aggregation type, and new measure name
TMDL measures — inserted into your measure table with proper DAX (SUM, AVERAGE, MIN, MAX, COUNTA)
Explore more in this category
