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

Sample Data

This table shows sales numbers for different products.

Cell	Value
A1	Product
A2	Apple
A3	Banana
A4	Cherry
B1	Sales
B2	100
B3	150
B4	120

Formula Trace

SalesFiltered = CALCULATE(SUM(Sales[Sales]), Sales[Product] = ParameterProduct)

Step 1: ParameterProduct = "Banana"

Step 2: Filter Sales where Product = ParameterProduct

Step 3: SUM(Sales[Sales]) on filtered rows

Step 4: CALCULATE(SUM(Sales[Sales]), Sales[Product] = ParameterProduct)

Cell Reference Map

    A        B
1 Product   Sales
2 Apple     100
3 Banana    150  <-- Filtered by ParameterProduct
4 Cherry    120

The formula uses the Sales table columns Product and Sales. The parameter 'ParameterProduct' is set to 'Banana', so only row 3 is included in the calculation.

Result

    A        B           C
1 Product   Sales    SalesFiltered
2 Apple     100       150
3 Banana    150       150
4 Cherry    120       150

The SalesFiltered measure shows the sum of sales for the product selected by the parameter, which is 150 for Banana, across all rows.

Sheet Trace Quiz - 3 Questions

What value does the parameter 'ParameterProduct' hold in this example?

A "Apple"

B "Banana"

C "Cherry"

D 150

Key Result

CALCULATE with a filter condition uses a parameter to dynamically filter data before aggregation.