How to use row field value in table lookup?

Hi  BenGWeeks ,

If [Area] is a determined value,

Try below measure:

AVERAGE=CALCULATE(AVERAGE(DevOpsAssessmentResponses[Area]),FILTER(ALL('DevOpsAssessmentResponses'),DevOpsAssessmentResponses[Area]="XXXXX"))

If [Area] is dynamic,

Try below measure:

AVERAGE=CALCULATE(AVERAGE(DevOpsAssessmentResponses[Area]),FILTER(ALL('DevOpsAssessmentResponses'),DevOpsAssessmentResponses[Area]=MAX(DevOpsAssessmentResponses[Area]))

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!