To include if blank then shows 0

[Apple08]

Hi All

I have a DAX below but I like to update it to show blanks as zeros.  Please could someone helps how to merge the DAX together:

YTD Age Group = var Max_AG_date = MAX ( 'fact_Staff_Data'[As at Date] )

--return Max_AG_date

var FiscalMth = Calculate ( Max ( dim_Dates[Fiscal Month] ),

                            Filter ( dim_Dates , 'dim_Dates'[Dates] = Max_AG_date )

)

return

CALCULATE ( [Count Age Group] ,

              filter ( dim_Dates , 'dim_Dates'[Fiscal Month] = FiscalMth )

            )

AND if blanks:

YTD no Blank = if(isblank([YTD Age Group]),0,[YTD Age Group])

Many thanks.

[Greg_Deckler · Accepted solution]

@Apple08 Try:

YTD Age Group = var Max_AG_date = MAX ( 'fact_Staff_Data'[As at Date] )
--return Max_AG_date

var FiscalMth = Calculate ( Max ( dim_Dates[Fiscal Month] ),
                            Filter ( dim_Dates , 'dim_Dates'[Dates] = Max_AG_date )
)

return
CALCULATE ( [Count Age Group] ,
              filter ( dim_Dates , 'dim_Dates'[Fiscal Month] = FiscalMth )
            ) + 0

[Apple08]

It works!  Many thanks Greg for the prompt reply. 🙂