When we are creating dashboards in Power BI using (for example) Act! tables, we may end up with a long list of tables. These could have come from Act! or from created tables, such as the Dates tables. In addition, we are going to want to create lots of measures.
This is where this little trick can come in very useful.
Setting Up Our New Measures Table
Within the Power BI desktop, click on the Enter Data button on the Home tab.
This will bring up the Create Table dialogue box. We are only interested in the Name field. Here we will enter the name of our new measures table, then click on Load to complete the task.
This will create a new table within the Power BI desktop. We can then start to move the measures to the new table.
Moving Measures to Our New Table
Go to the first table that holds a measure. Select the measure, then click the Modeling tab.
Within the Modeling tab we can move the measure from one table to another by using Home Table.
From the drop down list, select the new table. In the above example, at present Count_Lead_Source is sitting in TBL_Opp_Measures. To move it to the Measures Table table, we just click on the name of the new table in the list.
The measure is moved and is present in the new table.