Forum Discussion

BrettM's avatar
BrettM
Frequent Visitor
1 year ago
Solved

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?    BeforeToday = ...
Need Help
Show and Tell
  • GrowthNatives's avatar
    GrowthNatives
    1 year ago

    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's avatar
Hariharan_R
Solution Sage
1 year ago

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