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

This post is also available in: Deutsch

For a while, it was only possible to provide a Power BI report in multiple languages using workarounds. Recently, the enhanced dataset metadata has made it very easy to change the language of a report in Power BI, making it multilingual, for example in German and English. Since the Power BI September Update, the enhanced dataset metadata is now the standard for metadata, upgrading a Power BI report almost to the level of an SSAS Tabular Model.

Enhanced dataset metadata enables SSAS Tabular functionalities

One of these new capabilities is to offer the data model of each Power BI report in multiple languages.

The easiest way to maintain multiple languages is currently using