How do I make blank data show as 0?

[jonnyA]

Hello,

Let me first show you the measures I am using for this report ...

I believe this is the measure that will need to be tweaked ...

Count of Note ID = 
CALCULATE ( 
CALCULATE(DISTINCTCOUNT(rpt_DD_DailyLog_Dataset[Note_ID]), 
KEEPFILTERS ( rpt_DD_DailyLog_Dataset[Modifiers] in { "95", "GT", "GW~95", "GW~GT" }))) 
 
Total Encounters = 
CALCULATE ( 
CALCULATE(DISTINCTCOUNT(rpt_DD_DailyLog_Dataset[Note_ID]), 
KEEPFILTERS ( NOT ISBLANK ( rpt_DD_DailyLog_Dataset[Submitted_CPT] ) ), 
KEEPFILTERS ( NOT ISBLANK ( rpt_DD_DailyLog_Dataset[Billed_CPT] ) ) 
) ) 
  
% of Encounters Telehealth = 
DIVIDE([Count of Note ID], [Total Encounters]) 

Below, in the matrix, I have highlighted where the "Count of Note ID" is blank.  I would prefer that would show as a "0" so then the "% of Telehealth Encounters" would give the percenatge.

Let me know if you need any additional information and I will be more than happy to provide!

Thank you in advance!

[VijayP · Accepted solution]

@jonnyA 

Just Add +0 after the Formula., to get Zero instead of blank

[smpa01]

@jonnyA 

% of Encounters Telehealth = 
IF(DIVIDE([Count of Note ID], [Total Encounters])= BLANK(),0,DIVIDE([Count of Note ID], [Total Encounters]))

[VijayP · Accepted solution]

@jonnyA 

Just Add +0 after the Formula., to get Zero instead of blank

[jonnyA]

@VijayP only if all these formula's could be that simple!  That worked, thank you very much 🙂 !!!

[jonnyA · Accepted solution]

@VijayP  , your suggestion worked for the percentage formula, thank you very much!!! 🙂