How structurized and make order with DAX statements - best practices

[jaryszek]

Hello Guys,

How to make a structure to find easily all measures? How do you organize it? Maybe you are putting them into folder with page name or you have seperated measure table? 

How to not look for them in whole model while analyzing data? 

Best,
Jacek

[Poojara_D12]

Hi @jaryszek 

To keep your Power BI model organized and make it easy to find and manage measures, it's best practice to create a dedicated "Measures" table. This is a dummy table with no actual data, created solely to store all your DAX measures in one place, separating them from your fact and dimension tables. Once you’ve created this table, you can move all existing measures into it and then organize them using display folders. Display folders help categorize measures by topic, such as by report page (e.g., "Sales Page KPIs"), business area (e.g., "Finance Metrics", "Customer KPIs"), or function (e.g., "Time Intelligence", "Ratios"). Using a consistent naming convention for your measures—such as prefixing them with terms like "Total", "Avg", "YTD", etc.—makes it easier to identify them at a glance. Tools like Tabular Editor allow you to batch-manage folders, rename measures, and even document your DAX logic, which is especially helpful in large models. This structured approach prevents the need to search through the entire data model every time you want to find or modify a measure, greatly improving efficiency and model maintainability.

[jaryszek]

Curious about 1 measure table approach vs measures added to fct table...

What do you think about solution proposed by @FBergamaschi @Poojara_D12 ?
Why your solution is better? 

Best,
Jacek

[v-mdharahman]

Hi @jaryszek,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like you are looking for a way to organise your measures into a single place. As @FBergamaschi has already responded to your query, kindly go through the response and check if it solves your issue.

I would also take a moment to thank @FBergamaschi, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

[v-mdharahman]

Hi @jaryszek,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution. And if you're still looking for guidance, feel free to give us an update, we’re here for you.

Best Regards,

Hammad.

[jaryszek]

Hi, 

please do not close the topic. I still asked questions. 

[v-mdharahman]

Hi @jaryszek,

Thanks for getting back to us. I understand you still have questions, and we're here to help. Please take your time, and feel free to clarify your remaining questions or add any new details, and we'll do our best to assist you further.

Best regards,
Hammad.

[v-mdharahman]

Hi @jaryszek,
Hope everything’s going smoothly on your end. As we haven’t heard back from you, so I wanted to check if the issue got sorted.
Still stuck? No worries just drop us a message and we can jump back in on the issue.

Best Regards,

Hammad.

[jaryszek]

We are waiting for @Poojara_D12 why MeasureTable if better than Measure table per fct table as @FBergamaschi  proposed.

Please do not close topic. 

[FBergamaschi]

My suggestion is to avoid a table for measures (you lose the ocntext in which they work and will have issues in the drillthrough if you use a table for measures), but rather in each Fact Table they work on, create folders categorizing the measures. Then hide everyting apart from measures and dimensions, so you find them easily (you can hide multiple columns at the same time and move multiple measures at the same time in the model view)

If this helped please give kudos and/or mark as a solution

Best

FB

[jaryszek]

Thank you. It seems quite good. 

What if i will remove Fact table? What with measures then? 

[FBergamaschi]

If you remove a table, you lose the measures included. So you can keep it and just hide the columns. The model should include measures in fact table and columns in dimensions (sually hiding the keys)

Best

FB