title: Non-Additive Fact
body: <p>I have a Fact Table with 10 measures. out of 10 measures 9 are aggregated at Sum level.But I have Unit Price which is a Non-Additive Fact Measure.When I go to the property of Aggregation and make it none it does not work in SSAS and gives NULL values in the Cube once the cube is processed. So is there any way where I can deal with my Non-additive measure called Unit_Price.SO created a MDX. I don't know if this is the right method to do that or not. Here is my MDX.Please suggest a method to do the above.</p>
  
  <pre><code>with member [Measures].[Non Additive Unit Sales] as
    case when [Time].Level is [Time].[Month]
       and [Gender].Level is [Gender].[Gender]
       and [Customers].Level is [Customers].[Name]
       and [Product].Level is [Product].[Product Name]
    then [Measures].[Unit Sales]
    else null
    endselect
     {[Measures].[Unit Sales],
       [Measures].[Non Additive Unit Sales],
       [Measures].[Semi Additive Unit Sales]}
     * [Gender].Members ON COLUMNS,
    [Time].Members ON ROWS
  from [Sales]
  </code></pre>