SSAS Data Cube, how can I get an average instead of a sum as a dimension aggregation?
<p>I am working with a data cube that has a calculated member that is a percentage, and I need to get the aggregation for that member to be an average and not a sum.</p>

<p>Here is a screenshot or the cube in Excel:</p>

<p><a href="https://i.stack.imgur.com/l0wHi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/l0wHi.png" alt="enter image description here"></a></p>

<p>The bolded percentages are a sum, which makes no sense for a percentage. How can I get them to be an average of the grouped percentages?</p>

<p>The Unit ID is one dimension, and the Order ID is a separate dimension. An order contains a set of unit IDs. I tried to create a separate calculated member for orders, but I do not know how to represent this set in MDX, though in SQL it would be very easy.</p>

<p>In other words, I want to represent the following SQL statement as a set in MDX: </p>

<pre><code>SELECT [UnitSMA] WHERE [OrderKey] = &lt;OrderKey&gt;
</code></pre>