How to Create Measure Table in Power BI?

Recently, while working on a Power BI Report with 30+ measures, I found it challenging to track which measures belong to which table. To address this, Microsoft Power BI provides a solution by creating a table for better organization.

In this Power BI tutorial, we will explore the concept of a Power BI measure table and how to create measure table in Power BI. Additionally, we’ll cover the steps to create a folder in Power BI for better organization.

Also, I will tell you how to move measures from one table to another in Power BI.

Measure Table in Power BI

In Power BI, a measure table is a table that contains only measures rather than raw data.

Imagine you have a table with sales data and want to calculate the total and average sales. Instead of creating your original sales data table with these calculated values, you can create a measure table specifically for these calculations or measures.

How to Create Measure Table in Power BI

This example shows step-by-step instructions on creating a measure table in Power BI.

Here, I have a SharePoint list (Financial Sample) that contains the below columns with various data types:

Follow the below steps to create a measure table in Power BI:

1. Open Power BI Desktop and load the data. Then, you see data in the Data pane.

2. Under the Home tab, click Enter data.

3. In the Create Table window, give the name Measure Table and click the Load button.

4. In the Data pane, select Measure Table. Then, under the Table tools tab, click on the New measure.

5. In the formula bar, click the below expression. Then click Commit.

Total Sales = SUMX(
		'Financial Sample',
		'Financial Sample'[Units Sold] * 'Financial Sample'[Sale Price]
	)

Where:

• Total Sales = Name of the measure
• Financial Sample = Name of the Table
• Units Sold = Name of the Column
• Sale Price = Name of the Column

6. Under the Data pane, select Column 1 and right-click. A dialog box will appear; within this box, click “Delete from the model.”

7. In the Data Pane, our Measure Table was successfully created. You can see a small calculator icon on the table’s left side.

This way, you can create a measure table in Power BI Desktop.

How to Add Measure into Measure Table in Power BI

Here, we see, after creating the measure table, how to add measure in Power BI. Follow the below steps:

1. Select the Measure Table -> under the Table tools, click New measure.

2. In the formula bar, click the below expression. Then click Commit.

Average Sales = AVERAGE('Financial Sample'[Sale Price])

Where:

• Average Sales = Name of the measure
• AVERAGE = DAX Function
• Financial Sample = Name of the Table
• Sale Price = Name of the Column

3. After that, you see in the Data pene the Average Sales(Measure) added. Check the screenshot below.

This way, you can add measures in the Power BI measure table.

How to Create a Folder in Measure Table Power BI

Here, I will tell you how to create a folder in the measure table in Power BI. Follow the below steps.

1. Goto the Model view.

2. In the Data pane, select a column, measure, or calculated column you want to create a folder (you can select multiple items using Ctrl+Click)., then under the Properties pane, you will see the Display Folder, which gives the name of your folder in Power BI.

3. When you navigate to the Data pane under the Measure Table, you will observe a folder with an icon.

This method allows you to create a folder in the Measure Table and create folders in other tables similarly.

Power BI Move Measure to Another Table

In this example, let’s explore how to move measures from one table to another. Follow the steps below:

1. Now, please navigate to the Data pane and select the measure you wish to move to another table, such as Total Sales, in my case.

2. Under the Measure tools, expand the Home table, and select another table, in my case, Financial Sample.

3. You will notice that the selected measure (Total Sales) has been successfully moved to the Financial Sample table under the Data pane.

Using the above steps, you can move any measure from one table to another in Power BI.

Conclusion

You’ve learned how to create a measure table in Power BI. This tutorial covered the concepts of measure tables in Power BI, the steps to create a measure table, add measures, and create folders within the measure table for better organization.

Also, I covered how to move measures from one table to another in Power BI.

Moreover, you may like some more Power BI tutorials:

• Power BI COUNTIF Measure
• Power BI IF Statement Measure
• Export Matrix to Excel in Power BI
• Filter Measure in Power BI
• SUMX() Function in Power BI

Preeti Sahu

Preeti Sahu is an expert in Power Apps and has over six years of experience working with SharePoint Online and the Power Platform. She is the co-author of Microsoft Power Platform: A Deep Dive book. As a Power Platform developer, she has worked on developing various tools using Power Apps and Power Automate. She also makes Microsoft 365 videos and shares them on YouTube.