Forum Discussion
Power ParticipantWhat's more efficient - Multiple Linked Measures OR One Measure with Variables.
StuartSmith There are advantages/disadvantages to both. I would say that the "enterprise" best practice is multiple measures. But, for 80%-90% of the Power BI folks out there, I would say that single measures are preferred. Multiple measures make debugging an absolute nightmare. For the majority of the work I do, I use single measures. I *get* the "code reusability/maintainability" of having a single definition for things but for the vast majority of cases, so what if you have SUM('Table'[Column]) in 10 or 12 different places. If Microsoft would just allow us to have a measure return a table, then I would use the multiple measure approach more often, having intermediate measures that returned certain base filtered tables.
Community ChampionStuartSmith There are advantages/disadvantages to both. I would say that the "enterprise" best practice is multiple measures. But, for 80%-90% of the Power BI folks out there, I would say that single measures are preferred. Multiple measures make debugging an absolute nightmare. For the majority of the work I do, I use single measures. I *get* the "code reusability/maintainability" of having a single definition for things but for the vast majority of cases, so what if you have SUM('Table'[Column]) in 10 or 12 different places. If Microsoft would just allow us to have a measure return a table, then I would use the multiple measure approach more often, having intermediate measures that returned certain base filtered tables.
StuartSmithThats, thats what I am finding, the more measures you create referencing other measure, it becomes a spiders web and becomes unmanagable and untidy. I have started trying to create a single measure with vars to try and keep things neat, but was just curious as to what other people are doing.