Creating Measures is one of the more challenging to learn but greatest reward-giving features in Power BI.
One of the first things users of Measures learn is that you can store them in any table in the model.
For users who prefer to organize their models to ultra-high levels, having Measures scattered across multiple tables can be like having an itch you can’t scratch.
Power BI allows you to store all Measures in a “dummy” table, i.e., a table that contains only measures but no data fields.
Creating the Measures Table
To create the “dummy” table, select Home (tab) -> Date (group) -> Enter Data.
In the Create Table dialog box, give the new table a name like “Measures” and click Load.
NOTE: You can’t name the table “Measures” as that is a reserved word for Power BI.
We now have an empty table with a “dummy” field named “Column1”.
Moving Individual Measure to the Measures Table
To move a measure to a different table (like the newly created “My Measures” table), select the Measure then click the dropdown for Measure Tools (tab) -> Structure (group) -> Home Table and select the “My Measures” table.
The Measure has been moved to the new Measures table.
Bonus Trick #1: Converting the “Dummy” Table to an Official Measures Table
Because the “My Measures” table looks like every other table in the model, we can make it a bit more special by hiding the empty column named “Column1”. Right-click “Column1” and select Hide. The table has been moved to the top of the tables list and given an official Measures icon.
Moving Multiple Measures to the Measures Table
If you have many Measures that need to be moved to the “My Measures” table, moving them one at a time with the method described above can become tedious and time-consuming.
You can move multiple Measures in a single process by performing the following steps:
- Select the Model View.
- Expand the table(s) containing the Measures to be moved.
- Select the first Measure, press and hold the CTRL key, then select the remaining Measures.
- In the Properties panel, click the dropdown for Name and select “My Measures”.
All the selected Measures will now exist in the “My Measures” table.