0
0
Power BIbi_tool~10 mins

KPI visual in Power BI - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Monthly sales data for the first five months of the year.

CellValue
A1Month
B1Sales
A2Jan
B21000
A3Feb
B31200
A4Mar
B41100
A5Apr
B51300
A6May
B61250
Formula Trace
Total Sales = SUM(Sales[Sales])
Step 1: SUM(Sales[Sales])
Cell Reference Map
   A      B
1 Month  Sales
2 Jan    1000
3 Feb    1200
4 Mar    1100
5 Apr    1300
6 May    1250

Formula references all values in column B (Sales).
The formula sums all sales values from cells B2 to B6.
Result
   A      B       C
1 Month  Sales   Total Sales
2 Jan    1000    
3 Feb    1200    
4 Mar    1100    
5 Apr    1300    
6 May    1250    
7                5850
The KPI visual shows the total sales value 5850 calculated from the monthly sales data.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula SUM(Sales[Sales]) calculate?
AThe average sales value
BThe total of all sales values
CThe highest sales value
DThe number of sales entries
Key Result
SUM aggregates all values in a specified column to produce a total.