Organize Power BI DAX Measures in Folders

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail

Although very simple, still I see many Power BI reports with no organized way of separating measures. When you use Power BI for a while, you will gradually have more DAX measures and calculations, and having them organized under folders is always helpful. In this very short article, I’ll explain how you can use Display Folders in Power BI to organize your measures properly. If you like to read more about Power BI, read Power BI book from Rookie to Rock Star.

Measures unorganized

If you have just added calculated columns and measures in Power BI solution, your file will look like this in Power BI Desktop:

And this is an example of a file with only a few measures. I have seen examples with over 100 measures under a table. You can use the Search box of course to find something, but having them organized is always helpful.

What is the Display Folder?

It is simple to add a display folder in Power BI. Display folder is a virtual folder which can be used for fields (columns), calculated columns, and measures to group them together. Here is how a display folder looks like:

Creating Display Folder

One of the easiest ways to create a display folder is to go to the Model tab in Power BI Desktop.

Then select a column, measure, or calculated column (you can select multiple items using Ctrl+Click), then under Properties, you will see the Display Folder

As soon as you press Enter, you will see all of those measures (and/or columns) under a folder under that table:

Subfolder

If you want, you can create subfolders too. The way to create it is to put a \ in the display folder name, here is an example:

and this is how it will look like:

Measure Table

Each measure should be part of a table, however, that table would be like a placeholder only for that measure. Because the calculation of the measure would work regardless of which table it is located under. So it means that it really doesn’t matter which table you put your measures under, however, there are two approaches for this:

Put measures under their related tables

One approach is to put sales measures under Sales table, inventory measures under Inventory tables, etc. If you want to move measures from one table to another table, here is how you can move it:

Select the Measure (either in the Report tab or Data tab), then from the Modeling tab above, change the Home Table:

Put measures under a measure table

Another approach is to create one (or more) blank tables with no columns or fields, and then move all measures under that. Here is more explanation about it.

Summary

Having an organized list of measures is super helpful in further maintenance of your Power BI model. It is a simple work that saves you a lot of time in the future. Using tools such as Power BI Helper is also helpful to understand your model and DAX measures much more in details. Do you use the display folder or measure tables? if not, please let me know why, if yes, tell me down in the comments below how do you use it.

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
rssyoutuberssyoutube
Reza Rad on FacebookReza Rad on LinkedinReza Rad on TwitterReza Rad on Youtube
Reza Rad
Trainer, Consultant, Mentor
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for nine continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.
He wrote some books on MS SQL BI and also is writing some others, He was also an active member on online technical forums such as MSDN and Experts-Exchange, and was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the New Zealand Business Intelligence users group. He is also the author of very popular book Power BI from Rookie to Rock Star, which is free with more than 1700 pages of content and the Power BI Pro Architecture published by Apress.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.

7 thoughts on “Organize Power BI DAX Measures in Folders

Leave a Reply to Suzan Cancel reply

Your email address will not be published. Required fields are marked *