DAX AverageX with Duplicates

Hi,

Is there a way to write an AVERAGEX formula when there are duplicates, I know if you use a Measure so

Please Login or Register  to view this content.

so I thought if I used

Please Login or Register  to view this content.

, which of course didn't see the filter context, so
wrapped in Calculate but that took me back to the initial problem, is there a way around this apart from adding a unique column to the source.

I've attached a workbook showing both formulas, and also correct results in Excel, also a table with a usique column, but I'd like to see i a formula can work.

Richard.