Creating a Measures Table in Power BI
When navigating through your data model in Power BI Desktop, it’s easy to get lost, especially if you have a data model with several tables and a multitude of measures. In order to keep myself organized while developing, I like to create a Measures Table in my data model so that I can refer to this area anytime I am looking for a measure rather than scrolling and searching through the table lists.
Here is a step by step tutorial on how to create a Measures Table in Power BI.
In the Home tab of the Desktop ribbon, click Enter Data. This will pop up a screen that allows you to manually enter data. You can actually paste in data that you copied from Excel to this screen, but we’re not going to use that functionality right now.
For now we are going to rename the column to Measures and then rename the table name at the bottom to Measure Table. See the screenshot below.
Now you have a new table with one blank measure in it named Measures. Right click in your new table and click New measure. Enter in the calculation that you want to add to your report.
All measures that you create under this Measure Table can reference other tables in your data model. Since measures aren’t actually adding data to your model, only the measure itself lives here allowing you to separate out your measures from your other tables.
Clean Up & Uses
The last thing you will want to do is delete the original field that you created while making the table. In my case I named the column Measures, so go ahead and delete that Measures column from the Measure Table.
As you can see below, now you have a table specifically for storing your measures separate from the other tables in your data model.
Although this is something I practice, I understand why some people wouldn’t want to do this. I do it because it adds simplicity to my interactions with Power BI Desktop. I don’t have to scroll through 7 tables and hundreds of columns to find my measures. I know that I could easily use the Search field, but I feel like it makes my model more organized.
On the flip side, I understand how people would like the measures to be in the tables that they refer to. This would help people understand what tables measures were referring to without looking through the DAX.
Thanks so much for reading! If you have any comments, suggestions, or feedback make sure to email me at firstname.lastname@example.org.