Average based on criteria on same column

Removing '#No' from your visualisations changes context so I think you need something like this

Measure  = 
CALCULATE (
    AVERAGE(Table[% Completion]), 
    FILTER (
        ALL ( Table ), 
        Table[#No] = MAX ( Table[#No] )
    )
)