Suming a number of row entries in Microsoft list

[Brian874]

Hi ,

I have a Microsoft list which I have brought into power bi, the issue is I have several records where for example I have one record where the is a person name of Roy with the number 10 in a different field the next record and it has a  persons name of Roy with the number of 15 in a different field and another record where it has a person name of Mary with a number of  12 in a different field......all the numbers are in the same column.......what I want to do in power bi is show roy has 15 and mary has 12 as opposed to count the record which is currently showing me roy is 2 and mary is one.

Thanks in advance 🙂

[amitchandak · Accepted solution]

@Brian874 , if there is only one value repeating

sumx(Summarize(Table, Table[Person], Table[Value]), [Value])

or

sumx(Summarize(Table, Table[Person],"_1", MaX( Table[Value])), [_1])