Replace blanks with zero (0) in Matrix Table

[rbalza]

Hi Everyone,

Been reading in this community on how to handle blanks with zero values and unfortunately, none of them works in my current situation. So I have this matrix table with Rows [Job Manager] & [InvoiceNumber], Columns [Month & Year], Values [Sales]. Been using these tricks below and none of them really works. 

Sales =
IF ( SUM ( Invoices[Amount] ) = BLANK (), 0, SUM ( Invoices[Amount] ) )

Sales =
SUM ( Invoices[Amount] ) + 0

Relationship model

[amitchandak]

@rbalza , is month year coming from date table, if not table from there.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.