Issue
When 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
THEN "low"
ELSEIF SUM([Sales]) < 5000
THEN "Medium"
ELSE "High"
END
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.