Home » Power BI » Create a Measure table in Power BI

Create a Measure table in Power BI

Measure table banner

A Measure table is used to store some or all of the measures together in one place.

Suppose, you are working with multiple datasets and you have multiple measures under each dataset, so it becomes harder to find the measures between columns. So in that case you can use the measure table.

Note: Measure table contains only measures not columns.

Let’s Get Started-

Step-1: Create one table, Go to Home Tab > click on Table.

Create table in Power BI

Create table in Power BI

Step-2: Leave table empty and provide name to table & click on Load button.

Manual table in Power BI

Manual table in Power BI



Step-3: Table created successfully with one column.

Table created

Table created

Step-4: Now select the measure that you want to move in measure table.

Select measure >then choose measure table from Home table dropdown.

Move Measure into another table

Move Measure into another table

Step-6: Follow the same steps in case multiple datasets, go to dataset > select measure then select measure table.

Step-7: Now hide the column from measure table.

Hide Column

Hide Column



Step-8: Now your Measure table has been ready. Sometimes Measure table icon does not immediately change to the calculator icon. So here you have two option to change the icon –

  1. Save all changes & re-open the PBI file.
  2. Collapse & extend Fields Pane arrow icon.
MeasureTable

Measure Table

Refer Power BI other post: Power BI tutorials

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.

Leave a Reply