This blog shows how to use the Count funtion to get the count of the distinct values of a columns.

Example:

SELECT COUNT(DISTINCT Productnames) ProductCount
FROM DBO.Products

COUNT() - this is the function used to get the count.