Workspaces in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table shows three Power BI workspaces with their owners, number of members, and number of reports.

Cell	Value
A1	Workspace Name
B1	Owner
C1	Members
D1	Reports
A2	Sales Team
B2	Alice
C2	5
D2	3
A3	Marketing
B3	Bob
C3	4
D3	2
A4	Finance
B4	Carol
C4	3
D4	4

Formula Trace

=SUM(D2:D4)

Step 1: D2

Step 2: D3

Step 3: D4

Step 4: SUM(3, 2, 4)

Cell Reference Map

    A           B          C          D
1 | Workspace | Owner    | Members  | Reports
2 | Sales Team| Alice    | 5        | 3
3 | Marketing | Bob      | 4        | 2
4 | Finance   | Carol    | 3        | 4

Formula references cells D2, D3, and D4 for report counts.

The formula sums the number of reports from the three workspaces listed in cells D2 to D4.

Result

    A           B          C          D
1 | Workspace | Owner    | Members  | Reports
2 | Sales Team| Alice    | 5        | 3
3 | Marketing | Bob      | 4        | 2
4 | Finance   | Carol    | 3        | 4
5 |           |          | Total    | 9

The total number of reports across all workspaces is 9, shown in cell D5.

Sheet Trace Quiz - 3 Questions

Which cells does the formula =SUM(D2:D4) add together?

A Cells D2, D3, and D4

B Cells A2, B3, and C4

C Cells B2 to B4

D Cells C2, C3, and C4

Key Result

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