Dataflow entities in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table shows dataflow entities with their row and column counts.

Cell	Value
A1	Entity Name
B1	Rows
C1	Columns
A2	Customers
B2	1000
C2	5
A3	Orders
B3	5000
C3	7
A4	Products
B4	200
C4	4

Formula Trace

=SUM(B2:B4)

Step 1: B2

Step 2: B3

Step 3: B4

Step 4: SUM(1000, 5000, 200)

Cell Reference Map

    A          B          C
1 |Entity Name| Rows     | Columns  |
2 |Customers  | 1000  -->| 5        |
3 |Orders     | 5000  -->| 7        |
4 |Products   | 200   -->| 4        |

Cells B2 to B4 are referenced to sum the total rows across entities.

Result

    A          B          C
1 |Entity Name| Rows     | Columns  |
2 |Customers  | 1000     | 5        |
3 |Orders     | 5000     | 7        |
4 |Products   | 200      | 4        |
5 |Total Rows | 6200     |          |

The total rows from all entities are summed and displayed in cell B5.

Sheet Trace Quiz - 3 Questions

What does the formula =SUM(B2:B4) calculate?

A Number of entities

B Total number of columns in all entities

C Total number of rows in all entities

D Sum of entity names

Key Result

SUM(range) adds all numeric values in the specified cell range.