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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Non- Blank values should repeat downwards, where there are blank rows

Hello All,

 

I have a dax function which gives cumulative running sum for claims in my report. So here iam getting the expected values, However i have some blank rows in between so they should fill with the Non-blank value. Below is the dax function please help me if you aware of this. For ex : index 28 29 31 32 should fill with above non blank value 321. in the same way other blank rows should fill with their top non blank value

 

Claims running total in index =
CALCULATE(

SUM('Table'[Claims]),

FILTER(

ALLSELECTED('Table'[index]),

ISONORAFTER('table'[index], MAX('table'[index]), DESC)

)
So please modify the above dax function to show non blank values repeated where there are blank rows 
Thank you 

)

 

Prasad54_0-1695206238986.png

 

 

 

 

3 REPLIES 3
Anonymous
Not applicable

Hello All, 
Can anyone help on the above question, Thanks 

Anonymous
Not applicable

 

 

Hello @mlsx4 

Thank you for your help. 
The above dax function did not worked for me. 
So here i have a matrix table where iam showing index and claims in rows and date in columns. Here iam trying to achieve cumulative running sum for the claims. However iam getting correct values but also getting some blank values. So as per below table the above non blank value should repat where ever there is a blank below>

here iam using 
Index Column 
claims cloumn 
Date column 

 

Indexclaimsvalue for 9/19/2023claimsvalue for 9/18/2023
14622
28822
38822
48834
59934
69934
79934
810080
mlsx4
Memorable Member
Memorable Member

Hi @Anonymous 

It's difficult to know if it works without data, but try:

Claims running total in index =
CALCULATE( LASTNOBLANKVALUE(Table[index],SUM('Table'[Claims])),
'Table'[index]<= MAX('table'[index]),
REMOVEFILTERS()
)

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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