Column Value Doesn't Sum

[opuspocus254]

I am using a basic table visulization.  I have a column that has the values 1 or 0.  Both values exist in the source.  However, when I add this filed to the table it always displays 0.  The datatype is 'Whole Number' and there is a Sigma symbol in front of the field name. Other fields that are similar are working.  I've deleted and reuploaded the dataset (SQL Server view).

Any thoughts?