Forum Discussion
Convert Blank to Zero
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?
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 COALESCEBeforeToday = 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]
2 Replies
- GrowthNatives
Super User
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 COALESCEBeforeToday = 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
Solution Sage
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
