title: SSAS - Always show zeros - NOT blanks
body: <p>I have a cube that I access via Targit (BI Solution).  When I browse / use that cube I want all quantity results to be a zero if null / blank NOT a blank, but no matter what I try I get blanks.  I have changed the Null Processing property for the measure in question as well as attempted to change / remove the format string.  I still get blanks instead of zero's.</p>
  
  <p>Thoughts?</p>
  
  <p>UPDATE:  I figured out that I could create a calculated measure and use iif / isempty funcitons to force zeros.  This works - just wondering if there is a cleaner way to accomplish this.</p>
  
  <p>Thanks</p>
  
  <p>Bill</p>