How to do sum for a distinct column

[john_Learner]

Hi , I have 4 columns: 
Network Team, Pre sales, Demo score and Demo code. Now i need to filter distinct demo code and get the sum of demo score for the filtered demo codes.

output should have sum of demo score for unique demo codes.

Network Team Pre Sales Network ID Demo Score Demo code
SN8 SNB95 30 500131583
SN8 SNB95 30 500135175
SN8 SNB95 30 500151146
SN8 SNB95 30 500157277
SN8 SNB95 30 500159496
SN8 SNB95 30 500161054
SN8 SNB95 30 500163768
SN8 SNB95 60 500168156
SN8 SNB95 30 500176941
SN8 SNB95 30 500177938
SN8 SNB95 30 500178852
SN8 SNB95 30 500179668
SN8 SNB95 0 500180289
SN8 SNB95 30 500181796
SN8 SNB95 30 500185810
SN8 SNB95 60 500188107
SN8 SNB95 30 500190337
SN8 SNB95 30 500191211
SN8 SNB95 30 500191546
SN8 SNB95 30 500194877
SN8 SNB95 30 500195777
SN8 SNB95 30 500198717
SN8 SNB95 30 500202641
SN8 SNB95 30 500203523
SN8 SNB95 30 500203617
SN8 SNB95 30 500221736
SN8 SNB95 30 500223835
SN8 SNB95 30 500246684
SN2 SNB65 30 500199060
SN2 SNB65 30 500203113
SN2 SNB65 30 500203540
SN2 SNB65 30 500204924
SN8 SNB95 30 500198717
SN8 SNB95 30 500202641
SN8 SNB87 30 500025628
SN8 SNB87 30 500025948
SN8 SNB87 0 500026287
SN8 SNB87 30 500026474
SN8 SNB87 30 500029248
SN8 SNB87 30 500034051
SN8 SNB87 0 500034393
SN8 SNB87 30 500034396
SN8 SNB87 0 500034867
SN8 SNB87 30 500035992
SN8 SNB87 30 500036092
SN8 SNB87 0 500039025
SN8 SNB87 0 500040815

[john_Learner]

sorry its not giving me the desired result

[john_Learner]

need help please

[john_Learner]

please neeed help

[amitchandak]

@john_Learner ,

Sumx(Summarize(Table, Table[Demo code], Table[Demo Score]), [Demo Score])

Or

Sumx(Summarize(Table, Table[Demo code], "_1",Max(Table[Demo Score]) ), [Demo Score])