Best Practice for Centralising DAX Measures

[Anonymous]

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 for this?

My ideal world for this would be a single model that houses all measures then connect it to new and existing models and use the measures with in the measures model. I'd then be able to do mass changes across multiple models at once and not have inconsistency if we've had to do calculation changes.

Any assistance or thought processes on this would be amazing and greatly appreciated.

[Idrissshatila]

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]

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

[Idrissshatila]

Hello @Anonymous ,

yes, please check this 

 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💡