UPDATE [dataset1]

SET count_zzzzzz = count(placement)

from (select placement from [dataset1] ds1

      group by placement, data_source
     )
group by placement ;