Measure Folders – a way to maintain order in the model

Working with Power BI on small data models is not complicated. Problems start to arise as the complexity of the report we’re working on increases. Adding new data sources increases its volume, adding new tables, establishing relationships between them, and creating new calculations. Additionally, when our model already contains many tables and measures, and our client requests changes to a few calculations, it becomes increasingly difficult due to the scale of the solution. To effectively manage change in such reports, it is important to maintain proper order. This is not only about a well-thought-out data model, composed relationship views, or consistent field naming. What to do with measures if they are in different tables? The solution comes in the form of creating a “Measures Table” and then organizing folders in it. The solution is simple and significantly affects the convenience of working with the tool, especially when implementing new functionalities. How to create a Measures Table? Nothing simpler – in the Home ribbon, choose to manually create a table ‘Enter Data’ and name the table, for example, “_Measures”. Do not add any fields; let it be just an empty column. Then add your first measure there, and hide the empty column by right-clicking on it and selecting Hide. Your set of fields will look like the one in the screenshot below.
We already have a Measures Table. This is the first step to better organize your work with Power BI. What is the second one? Let’s move on to organizing measures in the table into folders. Notice that I have two types of measures here, general ones – containing, for example, the sum of sales, and cumulative ones (_Total). We will divide them into two folders: in the General folder, we will place general measures, and in Totals, we will place cumulative measures. To place measures in folders, go to the data model canvas and, while holding down the CTRL key, left-click the measures you want to place in one folder, and then in the ‘Display folder’ field, enter the folder name (in my case ‘Totals’). You will see everything in the screenshot below.
Ultimately, my set of fields looks like the one below.
Working with measure folders is definitely more enjoyable because in later stages, it is much easier to navigate our data model or guide users who take over the development of the report. Thanks to the organized and clear arrangement of fields, managing change is much simpler, reducing the risk of errors and saving time needed to make changes.

Interesting article? Share further!

Leave A Comment