How To Create A Measure Table In Power Bi

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;

Considerations

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.

Video

Trainer, Consultant, Mentor

Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years' experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for nine continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.
He wrote some books on MS SQL BI and also is writing some others, He was also an active member on online technical forums such as MSDN and Experts-Exchange, and was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the New Zealand Business Intelligence users group. He is also the author of very popular book Power BI from Rookie to Rock Star, which is free with more than 1700 pages of content and the Power BI Pro Architecture published by Apress.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza's passion is to help you find the best data solution, he is Data enthusiast.