Forum Discussion
Helper IIReplace 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' [Calendar Day] ),
'TY Group'[Country]="USA" && 'TY Group'[Calendar Day] = TODAY()-1))
Could anyone can help me to write this measure? Thank you!
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)) + 0Hi 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.
3 Replies
- Greg_Deckler
Community Champion
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
Advocate I
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.
- Ahmedx
Super User
add +0 at the end of the measure
