Convert Blank to Zero

[BrettM]

I am not getting the results I would expect from this measure where I am looking to have the result be "0" not BLANK. Where in this syntax would I enter the IF(ISBLANK statement? 

BeforeToday = CALCULATE(SUM(eCommOrdersByDate[Orders]), eCommOrdersByDate[Ship Date] < TODAY())

[GrowthNatives · Accepted solution]

Hi @BrettM , i understand you want to show zero instead of blanks. The ways I would so it are:

1. Using IF

BeforeToday = 
VAR Result = CALCULATE(SUM(eCommOrdersByDate[Orders]), eCommOrdersByDate[Ship Date] < TODAY())
RETURN IF(ISBLANK(Result), 0, Result)

2. Using COALESCE

BeforeToday = COALESCE(
CALCULATE(SUM(eCommOrdersByDate[Orders]), eCommOrdersByDate[Ship Date] < TODAY()),
0
)

 
⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together! 🚀 [Explore more] 

[Hariharan_R]

Hi @BrettM 

There are mulitple ways to show 0 if blank.

COALESCE([Measure], 0)

BeforeToday = 

var _value = CALCULATE(SUM(eCommOrdersByDate[Orders]), eCommOrdersByDate[Ship Date] < TODAY())

return

COALESCE(_value, 0)

Option 2: IF(ISBLANK([Measure]), 0, [Measure])

Thanks

Hari