Average from Calculated Measures in different Table

febrina , if these are different measure then you have to try like

( [Measure 1] + [Measure 2] + [Measure 3] + [Measure 4] + [Measure 5] + [Measure 6] + [Measure 7] + [Measure 8]) /8

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Hi febrina ,

You can create a measure with below code:-

AVERAGE =
VAR _num = [Measure1] + [Measure2] + [Measure3] + [Measure4] + [Measure5] + [Measure6] + [Measure7] + [Measure8]
VAR _den =
    IF ( ISBLANK ( [Measure1] ), 0, 1 ) + IF ( ISBLANK ( [Measure2] ), 0, 1 )
        + IF ( ISBLANK ( [Measure3] ), 0, 1 )
        + IF ( ISBLANK ( [Measure4] ), 0, 1 )
        + IF ( ISBLANK ( [Measure5] ), 0, 1 )
        + IF ( ISBLANK ( [Measure6] ), 0, 1 )
        + IF ( ISBLANK ( [Measure7] ), 0, 1 )
        + IF ( ISBLANK ( [Measure8] ), 0, 1 )
RETURN
    Divide(_num , _den)

Thanks,

Samarth