use strict;
use warnings;
use DBIx::Class;

my $rs = $schema->resultset('YOURTABLENAMEHERE')->search(
{},
  {
    columns => [ qw/name/ ],
    distinct => 1
  }
);

my $count = $rs->count;