title: MDX - Changing Infinity Value to Zero
body: <p>I have a calculated measure which returns Infinity in some cases due to a NULL division.</p>
  
  <p>My preference is just to change the MDX in the report rather than changing the cube etc. I want instead of infinity, which causes the 'Axis object - Auto interval error...' with a chart, to return 0 (zero) as this is the desired result.</p>
  
  <p>So far I've tried IsNothing([Measures.Budgets]) and IIF([Measures.Budgets] = "Infinity", 0, [Measures.Budgets]) to no avail.</p>
  
  <p>I'm quite new to MDX/SSAS so any help would be appreciated, cheers. </p>