How to move measure from one table to another in Power BI

Recently, I struggled to move the measures which I have created under wrong table in Power BI. I found an easy solution and here I’m with the post documenting my learnings.

The ability to move measures from one table to another table exists in Power BI.

The process is simple and much better than re-creating the measure again and deleting the old one.

Of course, it is not 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. It would make sense to place it appropriately if you have multiple measures around the same field.

Let’s begin.

First, select the measure. If you want to move multiple measures, press ctrl and select all the measures you want to move.

Then, after selecting the Measure, go to the Measure Tools (In the new layout of Power BI), and you will find the Home Table.

Point to Remember:

Sometimes Power BI automatically adds the table name before the measure name when you write DAX expression.

For example, let’s say you have a measure called XYZ, and it lives in the Table1. if you write a DAX expression like: Table1[XYZ]+2, then moving the measure into another table might cause an error in this expression.

That is why it is recommended to not have the table name before the measure names.

Hope you found the post informative. Your valuable feedback, question, or comments about this post are always welcome by leaving me message on  contact form is truly appreciated.