Replacing blank with Zero : Matrix

[Chandrashekar]

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

[v-tangjie-msft]

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.

[Chandrashekar]

Hello,

Thanks it is working perfectly 🙂

Regards,

Chandrashekar B

[amitchandak · Accepted solution]

@Chandrashekar , we usually add +0, to measure. Yet to check the file

[Chandrashekar]

Hello Amit,

am not using dax however using fields directly into visisuals.

Regards,

Chandrashekar B

[amitchandak]

@Chandrashekar , Refer to the attached file after signature, it requires model change and measure

[Chandrashekar]

Hello Amit,

Thanks for the solution. Can we get same for Average(Score Field) as well.

Regards,

Chandrashekar B

[Chandrashekar]

Hello,

Can we get same for Average(Score Field) as well.

Regards,

Chandrashekar B