Composite models in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table shows product sales data loaded from a DirectQuery source.

Cell	Value
A1	ProductID
B1	ProductName
C1	SalesAmount
A2	101
B2	Chair
C2	150
A3	102
B3	Table
C3	300
A4	103
B4	Lamp
C4	120

Formula Trace

Total Sales = SUM(Sales[SalesAmount]) + SUM(ImportedSales[SalesAmount])

Step 1: SUM(Sales[SalesAmount])

Step 2: SUM(ImportedSales[SalesAmount])

Step 3: 570 + 430

Cell Reference Map

    A       B           C
1 ProductID ProductName SalesAmount
2 101       Chair       150
3 102       Table       300
4 103       Lamp        120

ImportedSales Table (not shown in cells) has SalesAmount: 200, 230

Formula uses Sales[SalesAmount] and ImportedSales[SalesAmount]

The formula references Sales table's SalesAmount column (shown in cells) and ImportedSales table's SalesAmount column (imported data not shown in this grid).

Result

    D
1 Total Sales
2 1000

The calculated measure 'Total Sales' shows the combined sales amount from both DirectQuery and imported tables, totaling 1000.

Sheet Trace Quiz - 3 Questions

What does the formula 'SUM(Sales[SalesAmount])' calculate?

A Sum of sales amounts from the DirectQuery Sales table

B Sum of sales amounts from the imported ImportedSales table

C Sum of product IDs

D Count of sales records

Key Result

Composite models combine data from DirectQuery and imported tables by summing measures from both sources.