topic Re: Replacing blank with Zero : Matrix in DAX Commands and Tips

Replacing blank with Zero : Matrix

Chandrashekar — Thu, 01 Sep 2022 09:05:44 GMT

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

Re: Replacing blank with Zero : Matrix

amitchandak — Thu, 01 Sep 2022 09:57:29 GMT

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

Re: Replacing blank with Zero : Matrix

Chandrashekar — Thu, 01 Sep 2022 10:02:39 GMT

Hello Amit,

am not using dax however using fields directly into visisuals.

Regards,

Chandrashekar B

Re: Replacing blank with Zero : Matrix

amitchandak — Thu, 01 Sep 2022 15:28:11 GMT

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

Re: Replacing blank with Zero : Matrix

Chandrashekar — Fri, 02 Sep 2022 03:57:14 GMT

Hello Amit,

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

Regards,

Chandrashekar B

Re: Replacing blank with Zero : Matrix

Chandrashekar — Tue, 06 Sep 2022 05:54:46 GMT

Hello,

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

Regards,

Chandrashekar B

Re: Replacing blank with Zero : Matrix

Anonymous — Thu, 08 Sep 2022 09:16:15 GMT

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.

Re: Replacing blank with Zero : Matrix

Chandrashekar — Tue, 06 Sep 2022 10:08:17 GMT

Hello,

Thanks it is working perfectly 🙂

Regards,

Chandrashekar B