How to calculate an amount and average using several input rows

Hi Anonymous ,

Please have a try.

Create a table to delete repeat value.

Table 2 = DISTINCT('Table')

Create a measure to calculate the average.

Measure = CALCULATE(AVERAGE('Table 2'[Score]),FILTER(ALL('Table 2'),'Table 2'[Age]=SELECTEDVALUE('Table 2'[Age])&&'Table 2'[Gender]=SELECTEDVALUE('Table 2'[Gender])))

If I  misunderstood your meaning, please provide more details and desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.