Forum Discussion

Julia_Mav's avatar
Julia_Mav
Icon for Helper II rankHelper II
3 years ago
Solved

Replace BLANK with 0

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' [...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    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
  • Manendra's avatar
    Manendra
    3 years ago

    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.

Manendra's avatar
Manendra
Icon for Advocate I rankAdvocate I
3 years ago

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.