Average score with distinct - help

[wanass123]

Hi ! 

please I need the  average score for each problem with distinct response ID

Table : 

Response ID	Score	Problem
373135	25%	TV
373135	25%	TV
373094	50%	TV
373130	100%	Mobile
373160	25%	Mobile
373234	100%	TV
373234	100%	TV
373234	100%	Mobile
373234	100%	Mobile
373234	100%	TV
373234	100%	TV

expected result : 

Problem	Average Score
TV	58.33%
Mobile	75%

Thanks in advance .

[sidhiq91]

@wanass123  Could you please elaborate on the problem, sorry I am not able to understand your requirement and the expected output.

[wanass123]

Thanks sidhiq for your reply , please check I modified  the table score with % , data duplicated and I should not delete the duplicate , just I need to count the average  problem score for distinct response ID   please check table again . 

[BrunPierre · Accepted solution]

Avg(Aggr(Sum(Score)/Count(Problem),ResponseID,Problem))