Automatic Measure - Stop Summing ID

[FenTigger]

I'm working with a dataset from a commercial tool that my company uses as its risk register. I'm trying to create a heatmap visualisation. I don't have a lot of experience with using PowerBI with an external source - I've previously created this visualisation from an Excel spreadsheet, but we want to avoid faffing with the data each quarter.

When I've connected to the data source and imported the relevant table(s) some of the fields such as 'assessment_id' are being automatically summed. The clue is it's an id field, and therefore shouldn't be summed. How do I stop PowerBI automatically summing this (and other) fields?

All help gratefully received.

[jdbuchanan71]

You have to switch to the table view but you can also set the aggregation by right clicking on the field in the list.

[Anonymous]

Hi, answering an existing topic instead of creating a  new one.  

I'm continually hit with PowerBI automatically summing columns.

I don't see any Column Options tab.

[FenTigger]

Thanks!

[jdbuchanan71 · Accepted solution]

Go into the table view of your table.

Select the ID column.

In the Summarization dropdown pick 'Don't summarize'