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

[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

[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?