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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
soldous
Advocate II
Advocate II

Keep null rows after applying a measure

I have a table where for some columns in a row null values can appear and it is wanted. But when I add a simple SUM measure to this table null records are completely filtered out. Is there any way how to apply measure only for rows where there is a value but keep empty rows as well?

3 REPLIES 3
tamerj1
Super User
Super User

Measure =
VAR Clculation =
"your sum function"

VAR Result =
IF ( ISBLANK ( Clculation ),

"",

Clculation
)

RETURN

Result

you can replace "" with 0

amitchandak
Super User
Super User

@soldous , Try the option in visualization pane - Show item with no data or add +0 to you measure

 

ShowItemwithoutdata.JPG

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Show items with no data is not applicable because in some columns I don't want nulls but is some columns I do. Show items with no data shows all blanks.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.