PowerBI

Measure Killer: The Power BI External Tool We Wish We Had Found Sooner

Riddhi Shah
By Riddhi Shah
Mar 13, 2026
Measure Killer: The Power BI External Tool We Wish We Had Found Sooner

Measure Killer: The Power BI External Tool We Wish We Had Found Sooner

We'll be honest. The first time someone on our team heard "Measure Killer," the reaction was: wait, you want us to install that on a client's report?

But then at MagnusMinds we tried it. Now it's one of the first tools we open on any Power BI model older than a few months.

This quick guide shows exactly what Measure Killer does, why it matters, and how it keeps your reports clean, fast, and easy to hand over.

Key Concepts What Measure Killer Actually Does

  • Measure Killer is a free external tool for Power BI Desktop built by Kurt Buhler.

  • It scans your open PBIX file and finds every unused measure, column, and table.

  • It understands full DAX dependency chains so a measure called by another active measure is never flagged as unused.

  • No setup, no subscription, no cloud just click from the External Tools ribbon and it works instantly.

  • It shows the DAX expression right in the tool so you can review before deleting anything.

                    

Practical Use Cases How We Use It Every Day

  • Open any PBIX → External Tools → click Measure Killer → scan takes seconds.

  • Review the list of unused items (we usually see 20–30 % of measures are dead weight).

  • Keep anything still in progress; select the rest and delete in one click.

  • Works on leftover tables, old date tables, renamed columns everything that bloats your model.

  • Run it before handing over to clients, before production, or when a file feels “slow.”

Key Benefits – Why It Belongs in Every Toolkit

  • Faster reports – smaller models refresh quicker and load faster for users.

  • Easier maintenance – no more hunting through 130+ measures to find what’s active.

  • Cleaner handovers – new developers instantly see only what matters.

  • Completely safe – you stay in full control; nothing deletes without your confirmation.

  • Free forever – no catch, no paid tier.

  • Turns months of hidden clutter into a 15-minute cleanup job.

Quick Example

A client’s finance dashboard had 132 measures. After one Measure Killer scan we removed 78 unused ones. File size dropped 40 MB and refresh time halved. Total time: 12 minutes.

Conclusion

Measure Killer doesn’t promise magic, it just quietly solves a real problem that every Power BI developer faces.

Download it, run it on any report you haven’t cleaned lately, and you’ll see the difference in seconds. Your models will thank you and so will your team.

Ready to try it? Grab the free tool from the Power BI community and make it part of your standard process today.

 

TAGS PowerBI Optimization DAX
From Accounting to Analytics: Extending Xero Reporting with Power BI
Business-Intelligence
From Accounting to Analytics: Extending Xero Reporting with Power BI
Riddhi Shah
Mar 13, 2026

Many organizations use Xero as their primary accounting system and rely on its built-in reports for financial review. While these reports are accurate and reliable, they are designed for basic financial visibility, not for deeper analytics or visual exploration.  At MagnusMinds, we worked with a client who wanted to move beyond traditional accounting reports and gain clear, visual, decision-ready insights from their financial data without disrupting existing accounting processes.  The Reporting Limitation We Identified  The client was already using Xero effectively for accounting. However, their reporting workflow revealed a familiar pattern:  Financial reports were reviewed in tabular format  Limited visualization made trend analysis difficult  Comparing performance across periods required manual effort  Insights depended heavily on interpretation rather than visuals  The challenge wasn’t data accuracy it was how that data was being consumed.  Our Approach: Extending, Not Replacing Xero  Rather than extracting raw accounting transactions and recreating financial logic externally, we designed a solution that respected Xero as the system of record.  Our focus was on extending Xero’s reporting, not rebuilding it.  What We Did  1. Leveraged Xero’s Native Reports  We identified Xero’s financial reporting APIs as the most reliable source for analytics-ready data. This allowed us to work with figures that already aligned with Xero’s Profit & Loss and other financial statements.  2. Built a Custom API Integration  We implemented a custom API layer to extract financial report data from Xero automatically. This eliminated the need for manual exports and ensured consistent, repeatable data retrieval.  3. Structured the Data for Analytics  The extracted data was transformed into a clean, structured format suitable for Power BI. We kept the model intentionally lightweight to avoid unnecessary complexity.  4. Enabled Advanced Visualisation in Power BI  With accurate financial data available, we built interactive Power BI dashboards that introduced:  Profit & Loss visualisations with monthly and quarterly trends Revenue and expense breakdowns by account category and reporting period Comparative Profit & Loss views across financial periods Net profit and margin analysis with visual indicators Operating expense analysis aligned to Xero chart of accounts Period-over-period variance analysis for income and expenses Executive summary dashboards reflecting Xero’s financial statements at a glance All without altering the underlying accounting logic.  The Impact of Our Work  The solution delivered immediate and measurable benefits:  Financial reports became visually intuitive and easier to interpret  Manual reporting effort was significantly reduced  Data consistency with Xero was preserved  Leadership gained faster access to actionable insights  Reporting scaled effortlessly as business needs evolved  Most importantly, the client moved from reviewing numbers to understanding performance.  Why This Approach Works  Accounting systems and analytics platforms serve different purposes. By clearly separating responsibilities Xero for accounting and Power BI for analytics we avoided unnecessary risk and complexity.  Our approach ensured:  Accuracy was never compromised  Reporting remained flexible and scalable  Analytics evolved without impacting accounting operations  From Accounting to Analytics  This demonstrates how organisations can unlock greater value from existing accounting systems. With the right integration strategy, basic financial reports can be transformed into powerful analytical assets.  At MagnusMinds, we help organisations bridge the gap from accounting to analytics, turning trusted financial data into meaningful business insight.   

Read More
Riddhi Shah

About the Author

Riddhi Shah

Data & BI Lead skilled in delivering end-to-end data and application solutions across Power BI, SQL, Power Apps, ADF, and Python. Specialized in building intuitive dashboards, optimizing data models, and designing automated data pipelines that enable fast, reliable decision-making. Strong in DAX, ETL development, app customization, and workflow automation, with a focus on performance, usability, and data accuracy. Passionate about modernizing data systems, improving user experience, and empowering teams with impactful analytics and low-code solutions.

RECENT POSTS

CATEGORIES

TAGS CLOUD