The ability to move measures from one table to another table exists in Power BI, However, the process is not familiar for many users. Through my consulting and training work I have explained it to many of my clients. The process is simple and much better than re-creating the measure again and deleting the old one. Let me explain how it is in this post.
Measure in the Wrong Table
In this sample Power BI file, I have a measure for Sales, which mistakenly created under the DimCustomer table;
Nothing, of course, is wrong with having a measure in another table. because measures won’t have different behavior if they are located under an unrelated table. For measures, the calculation would run regardless of the table that they are in. However, for the scenario above, it would make more sense to have the Sales measure and other Sales related measures under the FactInternetSales table. Here is how you can move it;
Move the measure to another table
To move the measure to another table, here are the steps you need to do:
Select the Measure
To select the measure, in the Report or Data tab, click on the measure’s name (not on the checkbox, the checkbox is there to add the measure into a visual). by clicking on the measure’s name, you will see the measure is highlighted;
Measure Tools > Home Table (New Layout of Power BI)
After selecting the Measure, go to the Measure Tools (In the new layout of Power BI), and you will find the Home Table;
Modeling > Home Table (Old Layout of Power BI)
If you are still using the old layout of Power BI (in Power BI report server, or using Power BI without the most recent updates or features), you will find the Home Table under the Modeling tab;
Change the Home Table
Change the home table to the table that you want to be the new location (home) for the measure;
Now the measure should be moved to the new table;
Moving a measure from one table to another table is that simple, here are a few considerations, however:
- Measure calculation or evaluation is independent of the home table. Measures’ evaluation will run regardless of the home table.
- Some users prefer to keep all their measures in a blank table, called Measure table.
- Some users prefer to keep their measures under their related tables.
- You can organizer your measures even better by keeping them under Display Folder.