Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ppgandhi11
Helper V
Helper V

how to display 0 values?

Hi,

 

I have a measure as below:

 

TotalDenied = CALCULATE(count(Query1[IsWithinBM]), Query1[IsWithinBM] = "N")

 

Whenever the value of TotalDenied > 0, it displays fine, but when the value is 0, the report shows blank. How can I make it display 0 instead? Capture.PNG Please see the attached screenshot. Thank you!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi

A simple solution : Add +0 to your formula.

 

CALCULATE(count(Query1[IsWithinBM]), Query1[IsWithinBM] = "N") + 0

 

Zero.PNG

 

P.S: I got this idea few days back from a old post , dont remember exactly but i think it was Sean who posted this idea.

 

Thanks
Raj

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi

A simple solution : Add +0 to your formula.

 

CALCULATE(count(Query1[IsWithinBM]), Query1[IsWithinBM] = "N") + 0

 

Zero.PNG

 

P.S: I got this idea few days back from a old post , dont remember exactly but i think it was Sean who posted this idea.

 

Thanks
Raj

chotu27
Post Patron
Post Patron

Hi @ppgandhi11

 

I hope this below calculation will help you. And check the attached Pbix here

 

Create  seperate measures

 

Cases = SUM(Table1[TotalCases])

Aproved = SUM(Table1[TotalApproved])

 

Total Denied 1 = var denied = SUM(Table1[Total Denied])
         var aproved = [Aproved]
             
     return IF(ISBLANK([Aproved]),denied ,IF(ISBLANK(denied),0,denied))

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.