can Power BI create new column with aggregation based on groups?

Hi all, I have a question about the groupby/summarizecolumns question. I understand that we can perform groupby to new table. Suppose I have a table but I want the sum value to be added to the current table. For example, I have

I want a new column like:

is that possible?

Thank you very much