title: Show non empty levels in MDX
body: <p>How I can list levels for one dimension, which have non empty associated measure? </p>
  
  <p>Let assume that I have measure Budget. We created budget four times in a year, so this measure contains all of these values. I need to check only one prediction (category) in the report.</p>
  
  <p>This query returns me all levels:</p>
  
  <pre><code>WITH
  MEMBER [Measures].[Label] AS [Dim_Budget Category].[Category].CURRENTMEMBER.MEMBER_CAPTION 
  MEMBER [Measures].[Value] AS [Dim_Budget Category].[Category].CURRENTMEMBER.UNIQUENAME 
  
  SELECT 
  {
      [Measures].[Label], 
      [Measures].[Value]
  } ON 0,
  {
      [Dim_Budget Category].[Category].&amp;[BUDGET],
      [Dim_Budget Category].[Category].&amp;[YEP_1],
      [Dim_Budget Category].[Category].&amp;[YEP_2],
      [Dim_Budget Category].[Category].&amp;[YEP_3]
  } ON 1
  FROM [Retail] 
  </code></pre>
  
  <p>Now I am trying to add logic which check If category have any value in measure Budget. If yes, the query should return this level.</p>