The results of a cumulative calculation are accumulating in nature; therefore, sorting and filtering functionality is not available on calculated measure items that use cumulative functions in their expression. Those functions include the Cumulative Total, Cumulative Percent of Total, ABC Cumulative, and ABC Cumulative Percent of Total functions.
Sort and Filter options will not display on the pop-up menu of a calculated measure item that uses a cumulative function.
Sort and Filter properties will be disabled in the Properties window for those measure items.
If a non-cumulative calculated measure item has been sorted or filtered and you want to change it to a cumulative calculated measure item, you must first remove the sorting or filtering.
The view that follows shows an example of this scenario. The “Percent of Total” calculated measure item can be sorted and filtered because it does not perform a cumulative calculation. The “Cumulative % of Total” calculated measure item cannot be sorted and filtered.
Here's the pop-up menu for Percent of Total, with the Sort and Filter options:
Here's the pop-up menu for Cumulative Percent of Total, without Sort and Filter options:
The “Percent of Total” calculated measure item in the next view has a Recursive Top Count filter applied to it. If you attempted to change the expression for “Percent of Total” to a cumulative percent of total, a message would display stating that you need to remove the filter before the cumulative function can be applied to the expression.
