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.
Step-2: Leave table empty and provide name to table & click on Load button.
Step-3: Table created successfully with one column.
Step-4: Now select the measure that you want to move in measure table.
Select measure >then choose measure table from Home table dropdown.
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.
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 –
- Save all changes & re-open the PBI file.
- Collapse & extend Fields Pane arrow icon.
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.