How to NOT sum a field?

I'm creating my first PowerBI report. I am new to PowerBI report creation but have been creating reports and using SQL Server since 1998, though not as my full-time job.

Here's the thing. We recently were given access to a data warehouse repository using Amazon Redshift.  When I connect PowerBI to the Redshift instace,, the data come over fine, except for one column from one table.   This is an ID field, a foreign key to a table. However, when I connect it via PowerBI, the table appears as a sum.

It should not be a calculated field. I cannot see a way to "unsum" the field.  Using a direct conneciton SQL query on Redshift, I get teh field as an ID, as I expect.

What am I missing?

Thanks!