Power BI Measure Tables are a quick and effective way to keep your reports organized during development. They provide a place to keep track of the different custom measures you’ve created and can be further organized by creating folders within the new measure table.
Table of Contents
Why You Should Use Power BI Measure Table
Measure tables enable Power BI dashboards to have a cleaner working space, keep table columns separate from calculated values, and help keep developers organized when combined with folders, and standardized naming conventions.
The following example shows a Measure Table being utilized with folders to further keep measures organized.
Creating a table and adding folders only takes a few minutes to do.
How to Create a Power BI Measure Table
The processes to add a measure table to your report requires two steps. The first is making a new blank table that measures can be added to. The second is moving the existing measures in your report to the measure table. Optionally, you can also create folders to further organize measures on the table.
To create a measure table, Click “Enter Data” from the Home tab of the Power BI ribbon. A new blank table will be created. Name it “Measure Table”. Select the new table on the data panel prior to creating a New Measure to place it there. Measures can later be moved by changing their “Home Table”.
Step 1.) Create a Blank Table in Power BI
To create a blank table, click on Enter Data from the Home section of the Power BI Ribbon.
Name the new table and click on Load. There is no need to enter data into the table or rename the column. It won’t be used and can be deleted after adding measures to the table.
Once the table is generated, you will see it in the Data Panel of Power BI. With the measure table selected, you can create New Measures and they will be generated here.
After creating your first measure, you can delete Column1. If you delete the column before adding measures it will remove your entire table.
How to Move Measures Between Tables in Power BI
You can move measures between tables in Power BI by selecting the measure from the data panel, and changing the Home Table using the dropdown in the Measure Tools section of the Power BI Ribbon. The measure tools options are only available when you have a measure selected in the data panel.
Once measures are moved onto a measure table they can be further organized by placing them into folders.
Placing Power BI Measures in Folders
Folders for Measure Tables are created in the relationship editor screen of Power BI. To group measures, or non-measure fields together, go to the relationship editor. Then multi-select the field or measure names by left-clicking and holding SHIFT or CTRL. Then in the properties pane assign a Display Folder.
The following screenshot shows multiple measures selected on the right side of the data panel, and the display Folder being assigned in the Properties pane of the relationship editor.
After you press Enter, the Display folder is created in the Measure Table that is shown in the relationship tab. There are some additional options