title: MDX - Always return at least one row even if no data is available
body: <p>I am using the following MDX to pull a parameter:</p>
  
  <pre><code>WITH
      MEMBER [Measures].[Label] AS [Dim].[Hier].CURRENTMEMBER.NAME
      MEMBER [Measures].[Value] AS [Dim].[Hier].CURRENTMEMBER.UNIQUENAME
  
  SELECT
  {
      [Measures].[Label]
      , [Measures].[Value]
  }
  ON 0,
      NONEMPTY([Dim].[Hier].children, [Measures].[Measure])
  ON 1
  FROM [Cube]
  WHERE 
  (
  -- Criteria
  )
  </code></pre>
  
  <p>Sometimes, when selecting certain filtering criteria the query results in empty set. Instead, I would like it to display "N/A" in both value and label. Is it doable in MDX or should I use SSRS Calculated member to count rows in resulting dataset and substitute?</p>