SUMMARIZE() & ADDCOLUMNS() aren’t scary… if you can SEE them!
Have you ever needed to SUMX() over the values in more than one column? SUMMARIZE() can do it!
I tried solving this problem and the internet led me to SUMMARIZE(). It was stuffed inside another function and it confused me. I felt a lot like my friend in the above picture… discouraged. DAX had been so fluid until this point! There were learning curves and lots of new ideas, but I had never bumped into a function and heard my brain just say, “Nope.”