Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Dax

Hi,

 

I try to find a solution for the following:


My Matrix:

(The value is a count.)

 

 123
nr 1534
nr 241 
nr 39  

 

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;

 123
nr 1534
nr 241 1
nr 39 9 9

 

Thank you.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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

v-chuncz-msft
Community Support
Community Support

@Anonymous 

 

You may take a look at the following posts.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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,

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.