Hi Maaike,

I can't seem to reproduce your issue.

I created sets of members, then an aggregate of the set, combined it with an existing member and added totals. As you can see, the totals are correct and it doesn't ignore the calculated set totals:

I see you are using SSAS, is that OLAP or TABULAR? My example is OLAP.

Regards,

Ian

Hi Maaike,

Ah. Yes, it is a limitation in SSAS Tabular in that it sometimes chokes on creating totals that include calculated members that are totalled using the AGGREGATE function. We're not entirely sure in what circumstances this occurs and what the rules are and unfortunately MS seem reluctant to help us...

You may be able to work around it though by changing some of the Totalling options. Here's a similar View against Tabular that is totalling the calculated members:

To get this to work, you need to set the Rows and Columns options using the menu selections above and set the totalling to SUM rather than AGGREGATE and check the "include calculated members" option:

 

Let me know if that helps.

Ian