Dax

[Anonymous]

Hi,

I try to find a solution for the following:

My Matrix:

(The value is a count.)

	1	2	3
nr 1	5	3	4
nr 2	4	1
nr 3	9

As long as there is no data for "nr 2" for "3" I need the previous count ("nr2" & "2").

So basically the matrix should be filled in to be like this;

	1	2	3
nr 1	5	3	4
nr 2	4	1	1
nr 3	9	9	9

Thank you.

[Anonymous · Accepted solution]

I've rebuild the matrix in a new table in query editor and used the Fill down function.

[v-chuncz-msft]

@Anonymous 

You may take a look at the following posts.

• https://community.powerbi.com/t5/Desktop/How-to-show-zeroes-in-a-matrix-0-is-not-working/td-p/325999
• https://community.powerbi.com/t5/Desktop/Dax-Measure-Fill-Down-Value/m-p/594415#M282232

[Anonymous]

Hi, Thanks for your time. 

I've tried both solutions. Both measures are correct, but they give the same result as i had before, blanks are still blank.

I guess i might have to add a calculated column with a count for the biggest existing value and give this count if there is a blank... What do you think?

Kr,