Help on Formula

Hi Anonymous ，

Would you please try to use the following measure:

Scorecard 2 =
VAR A =
    CALCULATE (
        AVERAGE ( 'Sheet1'[Capability & offer] ),
        FILTER ( 'Sheet1', NOT ( ISBLANK ( 'Sheet1'[Capability & offer] ) ) )
    )
VAR B =
    CALCULATE (
        AVERAGE ( 'Sheet1'[Overall Performance] ),
        FILTER ( 'Sheet1', NOT ( ISBLANK ( 'Sheet1'[Overall Performance] ) ) )
    )
VAR C =
    CALCULATE (
        AVERAGE ( 'Sheet1'[Delivering with integrity] ),
        FILTER ( 'Sheet1', NOT ( ISBLANK ( 'Sheet1'[Delivering with integrity] ) ) )
    )
VAR D =
    CALCULATE (
        AVERAGE ( 'Sheet1'[Communicating effectively] ),
        FILTER ( 'Sheet1', NOT ( ISBLANK ( 'Sheet1'[Communicating effectively] ) ) )
    )
VAR E =
    CALCULATE (
        AVERAGE ( 'Sheet1'[Demonstrating right behaviours] ),
        FILTER (
            'Sheet1',
            NOT ( ISBLANK ( 'Sheet1'[Demonstrating right behaviours] ) )
        )
    )
VAR F =
    CALCULATE (
        AVERAGE ( 'Sheet1'[Knowing expectations] ),
        FILTER ( 'Sheet1', NOT ( ISBLANK ( 'Sheet1'[Knowing expectations] ) ) )
    )
VAR G =
    CALCULATE (
        AVERAGE ( 'Sheet1'[Health, safety & wellbeing] ),
        FILTER ( 'Sheet1', NOT ( ISBLANK ( 'Sheet1'[Health, safety & wellbeing] ) ) )
    )
RETURN
     ( A + B + C + D + E + F + G ) / 7

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

Best Regards,

Dedmon Dai