# Create measure if Blank value then set to 0

• ### Question

• Good afternoon,

I created this measure in Power Bi, however, when I selected for a visualization, I'd like to see 0 rather than blank.

EOB Repos = CALCULATE(sum('GL'[ABal]),value('GL'[Account_Number])= 21097800)

Jeannette

Wednesday, April 18, 2018 5:34 PM

• Hi,

Adding +0 at the end of your DAX formula will force Power Pivot to convert the value to a number, and blanks will become zeros.

EOB Repos = CALCULATE(sum('GL'[ABal]),value('GL'[Account_Number])= 21097800)+0

Ousama EL HOR

[If a post helps to resolve your issue, please click the "Mark as Answer"  of that post or click "Vote as helpful"  button of that post. By marking a post as Answered or Helpful, you help others find the answer faster. ]

[User Page]     [MSDN Page]     [Blog]     [Linkedin]

• Marked as answer by Wednesday, April 18, 2018 7:11 PM
Wednesday, April 18, 2018 5:39 PM

### All replies

• Hi,

Adding +0 at the end of your DAX formula will force Power Pivot to convert the value to a number, and blanks will become zeros.

EOB Repos = CALCULATE(sum('GL'[ABal]),value('GL'[Account_Number])= 21097800)+0

Ousama EL HOR

[If a post helps to resolve your issue, please click the "Mark as Answer"  of that post or click "Vote as helpful"  button of that post. By marking a post as Answered or Helpful, you help others find the answer faster. ]

[User Page]     [MSDN Page]     [Blog]     [Linkedin]

• Marked as answer by Wednesday, April 18, 2018 7:11 PM
Wednesday, April 18, 2018 5:39 PM
• Thank you Ousama!

This did the trick.

Wednesday, April 18, 2018 7:11 PM