When we have a look that combines measures and table calculations, there are times when we need the table calculation to be visibly in front of the measure. For example, when displaying a bar graph and wanting to have a calculated cumulative distribution function as a line, by default, the measure (the bars) appears in front of the calculation (the line). As a result, it is often impossible to see or select the data points on the line.
Because we cannot re-order table calculations in front of measures, we are forced to create a surrogate table calculation for the the measure and hide the original measure (e.g. if the measure is “orders per month”, we have to create a calculation called “order per month” that equals the measure, which we can then properly order).
Unfortunately, because drill fields can only be applied to measures, we cannot also have drill fields on such charts. This is a problem.
Ideally, we would simply be able to order table calculations before measures. However, it would also be nice if it were possible to associate a set of drill fields with a table calculation.
Either works for us. Both would be fantastic.