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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
webportal
Impactful Individual
Impactful Individual

Show a zero instead of blank in a matrix for dates within facts table

My calendar table has dates between 1-1-2000 and 31-12-2017.

However, the facts table, contains data only between 1-11-2016 and 1-3-2017.

In a measure, I used the the following expression to display a measure in a matrix:

Saldo em EUR = IF(ISBLANK(SUM('Table1'[Column1]));BLANK();CALCULATE( etc... ))

This measure checks if the sim of Column1 is blank and it shows a blank field in the matrix tough preventing it from showing all the dates range in the calendar table.

But - It also show a blank field for the dates within the facts table where there's no value for the sum of column1. 

I'd like it to show a zero instead of a blank field - how can I do that and still preventing the matrix from showing all the dates range in the calendar table?

Thanks in advance for helping!

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

Try adding + 0 either to the whole expression or just to the false argument (the CALCULATE part)

View solution in original post

1 REPLY 1
Sean
Community Champion
Community Champion

Try adding + 0 either to the whole expression or just to the false argument (the CALCULATE part)

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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