 <p>What you have done is almost correct. Just change <code>.currentmember</code> to an actual measure in your cube. Currently when you have the following it is referring to itself i.e. <code>currentmember</code> by the black arrow it referring to the measure <code>count</code> by the black arrow... </p> <p><img src="https://i.stack.imgur.com/4LJJU.png" alt="enter image description here"></p> <p>This is in <code>AdvWrks</code>:</p> <pre><code>SELECT {[Measures].[Internet Sales Amount]} ON 0 ,{[Product].[Product Categories].[Category]} ON 1 FROM [Adventure Works]; </code></pre> <p>It returns this:</p> <p><img src="https://i.stack.imgur.com/VBt1V.png" alt="enter image description here"></p> <p>If I want to replace the empty cell for Components the we can use <code>CASE</code>:</p> <pre><code>WITH MEMBER [Measures].[count] AS CASE [Measures].[Internet Sales Amount] WHEN 0 THEN "XXX" ELSE [Measures].[Internet Sales Amount] END ,format_string = "#,###,##0" SELECT { [Measures].[count] } ON 0 ,{[Product].[Product Categories].[Category]} ON 1 FROM [Adventure Works]; </code></pre> <p>This now returns this:</p> <p><img src="https://i.stack.imgur.com/NIl2Z.png" alt="enter image description here"></p> <p><code>IIF</code> is used a lot more in <code>MDX</code> than <code>CASE</code> - <code>IIF</code> is nearly always faster. So the above equivalent using <code>IIF</code> is the following:</p> <pre><code>WITH MEMBER [Measures].[count] AS IIF ( [Measures].[Internet Sales Amount] = 0 ,"XXX" ,[Measures].[Internet Sales Amount] ) ,format_string = "#,###,##0" SELECT {[Measures].[count]} ON 0 ,{[Product].[Product Categories].[Category]} ON 1 FROM [Adventure Works]; </code></pre>