Creating Calculations in Blended Charts and Tables

Create a calculation using measures and dimensions from multiple models.

You can create simple calculations using measures or account members from multiple models in your blended chart or table. When creating the formula in the formula editor, the auto-complete options will include measures from all your linked models.

You cannot use IF or ResultLookup functions in formulas that use multiple models.
Calculations in Blended Charts

In the Builder, members and dimensions from the primary model are identified with a dot.

Calculations in Blended Tables

When you switch between linked models for your blended table, the list of calculations will contain all the available calculations for the current model.