Sum based on text and value

[Anonymous]

Hi Experts

i need to sum based on client ID - so aaa should give me 2.25 and bcb 7 in a table as measure

Client ID	Data Value
aaa	1
aaa	0.5
aaa	0.75
bcb	1
bcb	2
bcb	4
bcb	1

[amitchandak · Accepted solution]

@Anonymous ,

sumx(summarize(Table, Table[client], Table[data value]), [Data Value])