Tip for Organising Power BI Measures

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.

Power BI Tables View

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.

Enter Data on 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.

Create Table view

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.

Modelling tab with measure

Within the Modeling tab we can move the measure from one table to another by using Home Table.

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.

Measures table in Home Table list

The measure is moved and is present in the new table. 

Moved measures to new table

Leave a Reply

one × two =

How Can We Help?

Find out how Caldere can help you to build a more successful business:
Call +44 (0)118 945 6220 and speak to one of our dedicated specialists.

Contact us!