How to sum a calculated measure?

ssas mdx data-warehouse olap ssas-2008
Jeffrey Bane picture Jeffrey Bane · Jun 28, 2013 · Viewed 9.1k times · Source

I have a fairly complex calculated measure that works perfectly for each row of data from a cube. However, I then need a sum of those values line by line. But the behavior of calculated measures seems to be in the subtotal and total lines in Excel, it's performing the calculation again instead of summing the previous rows. Is there a way to have a calculated measure that performs it's calculation on each row, but they does a traditional SUM in the total and subtotals?

Thanks in advance.

Answer

Marc Polizzi picture Marc Polizzi · Jun 29, 2013

A calculated measures does not aggregate; it will be computed each time.

Related questions

SSAS MDX WHERE clause syntax - filtering multiple values from the same hierarchy

I'm quite new to data warehousing and MDX queries, and I realize that I'm probably not using the MDX syntax properly in the case below. I'm using SSAS 2005 on MS SQL Server 2005 and would like to query my cube and …

Read More
List dimension members with MDX query

Is there a way to list dimension members without fetching default Measure for each member?

Read More
Difference between tuple and set in mdx

What is the difference between tuple and set in MDX. How we can distinguish both and when we are using them.

Read More