IssueWhen partitions in a view are created by an aggregate field, such as a table calculation or an IF statement, and another table calculation needs to return different results for each partition, then the aggregate field does not appear in the Compute Using options for the table calculation.
For example, if customers fall into one of three categories, "High", "Medium", or "Low", that are defined by the following calculation:
IF SUM([Sales]) < 500
ELSEIF SUM([Sales]) < 5000
Then [Customer Name] must be in the view for this bins to be calculated correctly. However, if [Customer Name] is in the view, then the marks in the view are broken up by [Customer Name], which means we will not have one sales total per category.