Forum Discussion

Resolver III

4 years ago

Solved

Replacing blank with Zero : Matrix

Hello, How to replace blank with zero in Matrix. Kindly note I am not using Dax to get values. Sample Data: Pbix Regards, Chandrashekar B

amitchandak
4 years ago
Chandrashekar , we usually add +0, to measure. Yet to check the file

Anonymous

Not applicable

4 years ago

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.