Power BI: Calculate total for each person with multiples submission

(0) Share

Report

Posted on by Nbz78

Hi all. Currently I'm having issue where I'm trying to get total points for each person. Also, I want to remove redundant names and make it as one. Refer to the example below:

What I have now:

Name	Points
Person A	100
Person A	95
Person A	70
Person A	60
Person B	66
Person B	84
Person C	90

What I want to get:

Name	Points
Person A	325
Person B	150
Person C	90

Thank you

All responses (1)

Answers (0)

Nbz78 64 on at

Like (0)

Report

Re: Power BI: Calculate total for each person with multiples submission

Hi thank you for your help! I managed to remove duplicate names and get the total points for each. Thanks again 🙂