Replacing blank with Zero : Matrix

Hi @Chandrashekar ,

Depending on your description, you want to replace the white space in the matrix with 0.

Here are my steps you can follow:

(1)This is my test data.

(2) Create a measure [MEASURE2].

Measure 2 =

DIVIDE(

    AVERAGE(Sheet1[Score]),

    CALCULATE(AVERAGE(Sheet1[Score]),ALLEXCEPT(Sheet1,Sheet1[A1/A2]))

) + 0

(3) Then we can meet your need , the result is as follows.

Best Regards,

Neeko Tang

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