What is a Measure table and how can I create it properly

This post is also available in: Deutsch

Although the feature has been in Power BI for a while, Measure Tables are not used enough in my opinion. Also during my trainings or in conversations with customers, I often notice that the feature has not really reached the minds of the report developers yet.

What is a Measure Table and what does it look like?

A measure table is an independent table that does not contain any columns and only the measures themselves:

Example of a Measure table
Example of a Measure table

When should I use a Measure table?

I personally use them when I have more than 4-5 measures. I find it more clear to have a large number of measures in a separate table instead of scattered between the columns of the fact table. But basically, you can also agree as a company to always use Measure Tables, which improves the user experience.

Instead of picking a specific measure from the table below:

Measures and columns mixed
Measures and columns mixed

…. is it easier to find a measure in the following table:

Measure table with folders
Measure table with folders

What are the special characteristics of the Mesaure table?

Including the just mentioned example of clarity, a Measure table has a few unique features:

  1. Own icon
    Unlike the other tables, the Measure table has a different icon, which makes it stand out from the other tables:
Measure table icon
  1. Always the first table
    Independent of the name of the table, it is always shown in the first place.
  2. Can be further organized with folders
    As shown in the last section, you can also use folders. This allows the Measures to be grouped further.
  3. Overview of the existing Measures
    As mentioned in the last section, this gives a nice overview of the available Measures. These are all in the same table, so you don’t have to “pick” them out among the other columns.

How can I create a measure table and move my existing measures to it?

Creating a Measure table is done in a few steps. There are many approaches, most of which involve creating a table and hiding the columns. In the following I will describe the best method from my point of view, because in this case we actually have a table with only measures and without any columns.

First, an empty table must be created using “Enter data”:

Create an empty table in Power BI
Create an empty table in Power BI

Afterwards, the existing measures have to be moved to this new table. There are two options available for this. For single measures this can be done by selecting the measure and changing the home table:

Move measure via "Home table"
Move measure via “Home table”

If you want to move several measures at once, it is worth doing this in one operation via the Model View:

Move multiple measures in the model view at once
Move multiple measures in the model view at once

After that, the initially created column can be deleted in the new table:

Delete the originally empty column
Delete the originally empty column

After closing and re-opening the Fields panel, the logo of the table has changed and the table appears in the top position:

After a fold and unfold of the Fields panel...
After a fold and unfold of the Fields panel…
... the logo has changed and the Measure table is in the first position
… the logo has changed and the Measure table is in the first position

Summary

The Measure tables are a good way to get a little more clarity into your reports. Even people switching from SSAS Multidimensional can usually manage this a bit better, since they are already familiar with a measure table from the old environment.

It can also be beneficial for the user experience to use a Measure Table. Finally, this makes it easier for the end user to find the measures they need.

Note: At the beginning of Measure Tables, there were difficulties with the Q&A feature and Measure Tables. However, this was fixed a long time ago, so there are no longer any limitations with Q&A and Measure Taables.

Denis Selimovic

Denis Selimovic

Trainer, Senior Consultant and Mentor for Power BI

Kommentare:

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x