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:

ColumnsData Types
SegmentSingle line of text
ProductSingle line of text
Unit SoldCurrency
Sale PriceCurrency
how to create table using measures in power bi

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.

how to add measure table in power bi

2. Under the Home tab, click Enter data.

how do you create a measures table in power bi

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

power bi measure table folder

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

How to add measure table power bi

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
create new measure table in power bi

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

create measure table power bi

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

How to Create Measure Table in Power BI

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.

how to add measure into measure table in power bi dax

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
How to Add Measure into Measure Table in Power BI

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

Power BI add Measures into Measure Table

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.

how to create folder in measure table in power bi

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.

create folder in measure table power bi

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

How to Create a Folder in Measure Table Power BI

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.

move measure to another table power bi

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

How to move Measure one table to Another Table

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

power bi move measure table to another table

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: