Sum data with custom suffix

Hey v-xuding-msft ,

the format looks great with your solution but the problem is, that i'm using a table to display the drive sizes of different virtual machines. In the raw data, there could be several records for one VM. i.e.

VM-DC-01   100      E:
VM-EX         900     D:
VM-FS       2000     F:
VM-DC-01     50     C:

So for the VM "VM-DC-01", my table should display the total (summed up) drive size of "150 GB". With your solution, i can't change to sum in the visual options for that field:

But by combining yours and sturlaws solution, i came as close as i can get! :) So thanks to the both of you!... (I would have to mark both of your comments as accepted solution... what's the best way to do that?)

I ended up with this measure, which works fine so far:

GB_Test = FORMAT(SUM('Table'[DriveSize]);"#,## GB")

Thanks to the both of you!

Edit (29.07.2019 08:55):

Now i found the downer for this solution. I can't sort by size in my table. The data gets sorted as text, which is not want i want (the screenshot shows a table where virtual machines are grouped by customer. Similar to the sample above) :(