According to BOL (emphasis is mine):
COUNT(ALL expression) evaluates expression for each row in a group and returns the number of nonnull values.
ALL is the default.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP