Tag Archives: 1.#INF

MDX and 1.#INF (Infinity)

There’s a knock at the door, its one of your users asking what the 1.#INF value is showing in today’s report.

The official reply is “There’s a problem with the server” … this will buy you enough time to race back to your SSAS solution and make the following adjustment to your calculation and redeploy before the user gets back to their desk… 🙂 We need to check if Measure B is 0 (to make the calculation null) otherwise carry out the division as normal.

IIF(
Measures.[Measure B]=0,null,
Measures.[Measure A] / Measures.[Measure B]

)

Scenario explained here …

http://msdn.microsoft.com/en-us/library/ms144717.aspx

A twist on this scenario here, the solution involving checking if the parent member is null …

Thomas I Blog