EDIT: A new feature called "Insight over Result Sets" has been added that helps address this issue. See my comment below from 4/6/22 for more details. It would be nice to be able to be able to reference the results of a measure in a separate measure to make variance calculations easier in an Aggregated Table. There can be cases where measure columns have different filters or nested aggregations that make comparing two values difficult or impossible in the current formula editor. Imagine an example where we have four measures: Actuals, Budget, Variance, and Margin %. We can create measures that have the appropriate filters on them for Actuals and Budget, but it would be great to reference the results of those measures in the Variance and Margin % measures. We should be able to have a formula that is Actuals - Budget for Variance, and Variance / Budget for the Margin %. There are ways to get around this at the Schema and Business Schema layers today, but it would be great if this could be solved within the Insight itself.
... View more