How to Delete Multiple Measures in Power BI

Trying to clean up your Power BI report and finding you can't select and delete multiple measures at once can be a real headache. Unlike dealing with a list of files or cells in Excel, Power BI’s Fields pane doesn't let you hold down Ctrl and click to remove several measures simultaneously. This article will show you two effective and straightforward methods to get this done, saving you from the tedious process of deleting them one by one.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Can't You Just Multi-Select and Delete?

If you're coming from just about any other software, the inability to multi-select items in a list feels strange. In the Power BI Desktop "Fields" pane, when you hold the Ctrl key and click on multiple measures, only the last measure you clicked remains selected. This isn't a bug, it's a long-standing design choice in the Power BI interface.

This limitation forces users to hunt for more efficient workarounds, especially when dealing with complex models that have dozens or even hundreds of redundant or outdated measures. Manually right-clicking and deleting each one is not only slow but also increases the chances of accidentally deleting the wrong thing. Let's look at the proven, faster methods to bulk-delete measures.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 1: Using the Model View in Power BI Desktop

The simplest way to delete multiple measures without leaving Power BI is by using the Model view. This view is designed for managing relationships between your tables, but it also includes a handy feature that allows for multi-selecting columns and measures within a single table card. This method is perfect if all the measures you want to delete are in the same table.

Step-by-Step Instructions

1. Switch to Model View: In Power BI Desktop, look at the left-hand navigation pane. Click on the icon that looks like a diagram of connected tables to open the "Model view." You'll see your data tables represented as cards.
2. Locate Your Table: Find the table card that contains the set of measures you need to remove. You'll see them listed along with any columns in that table. Measures are typically marked with a calculator icon.
3. Multi-Select the Measures: Hold down the Ctrl key on your keyboard. While keeping it pressed, click on each measure you want to delete within that table card. You'll see them all become highlighted as you select them.
4. Delete the Selected Measures: Once all target measures are highlighted, either press the Delete key on your keyboard or right-click any of the highlighted measures and choose "Delete from model" from the context menu.
5. Confirm the Deletion: Power BI will show a confirmation dialog box listing all the measures you're about to delete. Review the list carefully. If it's correct, click "OK" to permanently remove them.

Pros: This method is quick, easy, and doesn't require any external tools. It's built right into Power BI.

Cons: It only works for measures that are within the same table. If you need to delete measures scattered across multiple tables, you'll need to repeat this process for each table, which can still be a bit slow.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 2: Using Tabular Editor for Bulk Operations

For more heavy-duty cleanup or for deleting measures across many different tables at once, the best tool for the job is Tabular Editor. It's a free, third-party tool that allows you to directly manipulate the Tabular Object Model (TOM) of your Power BI file. It's widely used by Power BI professionals to speed up development and perform bulk actions that are clumsy or impossible within the standard Power BI interface.

This option has a slightly steeper learning curve, but it is extremely faster in many regards.

Step-by-Step Instructions

1. Install and Launch Tabular Editor: First, you need to download and install Tabular Editor 2 (the free version is all you need). Once installed, it will appear in the "External Tools" ribbon in Power BI Desktop.
2. Connect to Your Model: With your Power BI report open, go to the "External Tools" tab and click "Tabular Editor." This will launch Tabular Editor and automatically connect it to your open PBIX file’s data model. Important: always make a backup of any important file before trying this for the first time!
3. Navigate to Your Measures: In the Tabular Editor window, you'll see a tree view called "TOM Explorer" on the left. Expand the "Tables" folder. Here, you will see all your tables. Unlike in Power BI's Model view, you can multi-select items across different tables.
4. Select Measures Across Multiple Tables: Expand the first table, hold Ctrl, and click the measures you want to delete. Without letting go of Ctrl, scroll to another table, expand it, and continue selecting more measures. You can select measures from as many different tables as you need, all in one go.
5. Delete the Measures: With all the desired measures selected, just press the Delete key. One of Tabular Editor's best features is its ability to warn you if any of the measures in question are being used by others, a great way to prevent broken reports.
6. Save Changes to the Model: After deleting the measures, go to File > Save in Tabular Editor (or press Ctrl+S). So far, you've only made changes in Tabular Editor, this step saves them back to your Power BI data model.
7. Refresh in Power BI: Go back to your Power BI Desktop window. A yellow bar will appear at the top with the message, "External tool changes have been detected." Click "Refresh now."

The measures will now be gone from your report. While using an external tool might seem intimidating at first, the time saved and the added control make it an essential part of any serious Power BI developer's toolkit and a habit that pays dividends in productivity.

Using C#-Scripting in Tabular Editor to Be Even Faster

The other huge plus of an external-tool approach like this is that you may also schedule certain measure deletions on an event you choose, or even find-and-replace a certain naming convention through C#-scripting like this:

Say you wish to delete from your tables every measure that contains OLD-.... This can be done by running a C# scripting command with Tabular Editor and using the code below:

foreach(var m in Model.AllMeasures.Where(m => m.Name.Contains("OLD-"))) { m.Delete(), }

Just one command to delete dozens, hundreds, or even thousands of unneeded measures.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Final Thoughts

Cleaning up your Power BI models by deleting old or unnecessary measures is key to keeping your reports efficient and easy to navigate. While Power BI Desktop lacks a direct multi-select delete option in its main view, using the Model View is a great trick for simple cleanups within a single table. For larger, more complex tasks spread across your whole model, adopting a tool like Tabular Editor will save you a massive amount of time and effort.

Mastering these workflows is just one way to streamline your data analysis process. After cleaning up your measures, you might ask yourself "so where do I really begin?", and if you’d like to bypass the manual setup of reporting dashboards and data sources entirely, you should definitely give Graphed a shot. We connect to a dozen different marketing and sales platforms you rely on every day to pull all of your most precious data for you, without you having to lift a finger after your preliminary setup. Since it leverages a natural language model like the one used by ChatGPT, you can ask it to create and visualize entire dashboards just by chatting.