Replace BLANK with 0

[Julia_Mav]

Hi all,

I want to replace Blank for Sales USD with 0 for the measure attached below.

For yesterday =

CALCULATE(

    [Sales USD],

    FILTER (

        ALL ( 'TY Group'[Country],'TY Group' [Calendar Day] ),

        'TY Group'[Country]="USA" && 'TY Group'[Calendar Day]  = TODAY()-1))

Could anyone can help me to write this measure? Thank you!

[Greg_Deckler · Accepted solution]

@Julia_Mav Try:

For yesterday =

CALCULATE(

    [Sales USD],

    FILTER (

        ALL ( 'TY Group'[Country],'TY Group' [Calendar Day] ),

        'TY Group'[Country]="USA" && 'TY Group'[Calendar Day]  = TODAY()-1)) + 0

[Ahmedx]

add +0 at the end of the measure

[Manendra · Accepted solution]

Hi @Julia_Mav 

Just add +0 at the end of your measure.

Ex: 

For yesterday =

CALCULATE(

    [Sales USD],

    FILTER (

        ALL ( 'TY Group'[Country],'TY Group' [Calendar Day] ),

        'TY Group'[Country]="USA" && 'TY Group'[Calendar Day]  = TODAY()-1))+0

This should solve your problem, if not do let me know.

Cheers,

Manendra.

[Greg_Deckler · Accepted solution]

@Julia_Mav Try:

For yesterday =

CALCULATE(

    [Sales USD],

    FILTER (

        ALL ( 'TY Group'[Country],'TY Group' [Calendar Day] ),

        'TY Group'[Country]="USA" && 'TY Group'[Calendar Day]  = TODAY()-1)) + 0