If you’ve been working in Power BI for a while, you’ve probably noticed how messy the Fields pane can get. Between multiple fact tables, dimension tables, and calculated columns, it’s easy to lose track of your measures. That’s where a Measure Table comes in handy.

A Measure Table is a dedicated table that contains only your measures. No actual data, no clutter, just the calculations you use in your reports. Using a Measure Table keeps your model organized, readable, and easier to maintain.

Why Use a Measure Table?

1. Organization – instead of measures being scattered across multiple tables, they’re all in one place
2. Clarity – when someone else looks at your model, it’s obvious where to find measures
3. Maintenance – adding or updating measures is simpler and you don’t have to hunt through multiple tables

How To

Step 1: Create a Blank Table

Go to Modeling > New Table and enter:

My Measures = {1}

//This creates a table with a single value. We’ll hide this placeholder column later.//

Step 2: Add Measures

Create a new measure and assign it to the Measures table. For example:

Total Sales = SUM(Sales[Amount])

You can repeat this for all your key calculations to keep them centralized.

If you already have measures in your model, click on the measure. Then in the ribbon under Measure Tools, use the Home Table dropdown to reassign it to your new Measure Table. You don’t need to recreate anything.

Step 3: Hide the Dummy Column

Right-click the (Value) column in the Fields pane and choose Hide in report view. Now your table contains only the measures and looks clean.

Taking it a Step further…

Did you know you can also create a folder within a table to further organize your measures?

Switch to Model (Relationship) View
Click the Model icon on the left sidebar in Power BI Desktop.

Select a Measure
Click on the measure you want to organize.

Open the Properties Pane
If the Properties pane isn’t visible, go to View in the top menu and check Properties.

Assign a Display Folder
In the Properties pane, find the Display folder field. Enter the folder name you want & Press Enter.

Once you have folders created you can drag existing measures into it.

To create subfolders, use a backslash: Project Ledger Entries/Extras

A Measure Table is a small change with a big impact. It makes your Power BI models more organized, easier to maintain, and much easier for anyone else to work with. If you haven’t used one yet, try it in your next project and you’ll wonder how you managed without it.