Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Best Practice for Centralising DAX Measures

Hello,   I'm looking at having a potential DAX library to hold measures across the entire business so I have uniform and consistency across all measures and models.   What is the best practice fo...
Need Help
Tips and Tricks
Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
3 years ago

Hello Anonymous ,

 

So yes you could build one data model that has the tables and measures and then publish it to service and connect the new reports to it as a dataset.

 

check it out here https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets

 

also make sure you build your model as star schema model https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

 

Also you could use calculated group to creat a group of measure and display all of them at once 

check it out https://youtu.be/a4zYT-N-zsU?si=B6OU5tz736U4gjje

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Idrissshatila,

     

    Appreciate the response but that's not what I am looking for. I'm wanting to have DAX measures centralised for all current and new models so its easier for source control and my sanity! 

     

    Thanks