title: MDX - How skip 0 values in MIN agregation and how exclude some percent of results?
body: <p>In my cube I have</p>
  
  <ul>
  <li>Earnings as measure with <code>MIN</code> aggregation</li>
  <li>Dimension: [Localization].[Type].&amp;[center]</li>
  <li>Dimension: {[Date].[Year].&amp;[2017], [Date].[Year].&amp;[2018]}</li>
  </ul>
  
  <p>My query is: </p>
  
  <pre><code>What are the minimum earnings of the person who decides to buy
  apartments in the city center, excluding 5% of the lowest, within
  last 2 years?
  </code></pre>
  
  <p>Now my mdx query looks like that:</p>
  
  <pre><code>SELECT
  [Measures].[MinEarnings] ON COLUMNS
  FROM [cube]
  WHERE
  (
      BottomCount ([Localization].[Type].&amp;[center], 95, [Measures].[MinEarnings]),
      {[Date].[Year].&amp;[2017], [Date].[Year].&amp;[2018]}
  )
  </code></pre>
  
  <p>I have two problems:</p>
  
  <ol>
  <li>Some earnings are 0 - how can I skip them in calculations?</li>
  <li>If my query correctly excludes 5% of the lowest earnings?</li>
  </ol>