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] 

GrowthNatives's avatar
GrowthNatives
Super User
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]