Overall Percent Complete

Group by State, then aggregate by MAX Percent Complete.  (unless you have scenarios where they modify the percentage down too)

Thanks for the reply from lbendlin , please allow me to provide another insight:

Hi Reino66 ,

You can try formula like below to create measure:

Overall Percent Complete = 
VAR MaxPercentByState =
    SUMMARIZE(
        'Table',
        'Table'[State],
        "MaxPercent", MAX('Table'[Percent Complete])
    )
RETURN
    AVERAGEX(MaxPercentByState, [MaxPercent])

Best Regards,
Adamk Kong

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