Forum Discussion
Challenges with ALLSELECTED and iterators
MattBI, I think the answer to this also is that it really just depends on the application. If you wanted to do just a basic output then yes ADDCOLUMNS is more preferred, however, if you want to do a categorical sum or rollup then SUMMARIZE alone is sufficient. I use both methodlogy just depends on what is required for my specific circumstances.
If by adjusting any formula or expression making it more complicated without any clear performance gains within your model then you're doing it wrong. Just my opinion.
Thanks again for your response. I hear what you're saying. Unfortunately, as I mentioned above, using SUMMARIZE as you suggested returned no data for the rows in my output set. Using ADDCOLUMNS instead returned results, but they were the same as what I was seeing originally so unfortunately, it didn't help improve the situation.