DAX for matrix table

Hi Kay_Kalu 

Please try the following measure:

VAR _avg1 =
    AVERAGEX (
        FILTER (
            SUMMARIZECOLUMNS (
                'table'[Checking Parent],
                "@value1", [total number of checks  measure],
                "@value2", [total sql no feedback measure],
                "@value3", [sql fail rate]
            ),
            [@value1] > 0
                && [@value2] > 0
        ),
        [@value3]
    )
VAR _avg2 =
    AVERAGEX (
        FILTER (
            SUMMARIZECOLUMNS (
                'table'[Checking Parent],
                "@value1", [total number of checks  measure],
                "@value2", [total sql feedback measure],
                "@value3", [total sql no feedback measure]
            ),
            [@value1] > 0
                && [@value2] > 0
        ),
        [@value3]
    )
VAR _avg3 =
    AVERAGEX (
        FILTER (
            SUMMARIZECOLUMNS (
                'table'[Checking Parent],
                "@value1", [total number of checks  measure],
                "@value2", [total sql feedback measure],
                "@value3", [total sql feedback measure],
                "@value4", [sql fail rate measure]
            ),
            [@value1] > 0
                && [@value2] > 0
                && [@value3] > 0
        ),
        [@value4]
    )
RETURN
    ROUND ( _avg1 + _avg2 - _avg3, 2 )

If this doesn't work, please provide a sanitized copy of your PBIX (confidential data removed) stored in the cloud.