SUM Error 4,52 (String)

[Patrick89]

Hello everyone,

I'm new here and it's my first time.

I am slowly starting to get to know PowerBI.

Now I have values in a column "Quantity affected". I would like these to be displayed as a total in a card. But I get the following error message (see screenshot below). What am I doing wrong? Thank you for your help

Best regards

Patrick

[Anonymous]

Hi @Patrick89 ,

Whether the advice given by @HotChilli  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Best Regards,

Neeko Tang

[HotChilli · Accepted solution]

Trying to add (using SUM) a column of strings?  That won't work, it needs a numeric datatype