Forum Discussion
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 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.
3 Replies
- Idrissshatila
Super User
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💡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💡
