Card and multi-row card in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table shows sales amounts for three products.

Cell	Value
A1	Product
B1	Sales
A2	Apples
B2	100
A3	Bananas
B3	150
A4	Cherries
B4	200

Formula Trace

Total Sales = SUM(Sales[Sales])

Step 1: SUM(Sales[Sales])

Step 2: 100 + 150 + 200

Cell Reference Map

   A        B
1 Product  Sales
2 Apples   100
3 Bananas  150
4 Cherries 200

Arrows: SUM reads B2, B3, B4

The formula references the Sales column cells B2, B3, and B4 to calculate total sales.

Result

   A        B        C
1 Product  Sales    Card
2 Apples   100      450
3 Bananas  150
4 Cherries 200

Multi-row card would show:
Product: Apples, Sales: 100
Product: Bananas, Sales: 150
Product: Cherries, Sales: 200

The Card visual shows the total sales value 450. The Multi-row card lists each product with its sales amount.

Sheet Trace Quiz - 3 Questions

What does the Card visual display in this example?

A The average sales value

B The sales value of the first product only

C The sum of all sales values

D The number of products

Key Result

SUM aggregates all values in a column to produce a single total.