0
0
Power BIbi_tool~10 mins

Why DAX powers calculations in Power BI - Formula Trace Breakdown

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Sales data for different fruits showing product names and their sales amounts.

CellValue
A1Product
B1Sales
A2Apples
B2100
A3Bananas
B3150
A4Cherries
B4200
Formula Trace
Total Sales = SUM(Sales[Sales])
Step 1: SUM(Sales[Sales])
Cell Reference Map
   A        B
1 Product  Sales
2 Apples   100
3 Bananas  150
4 Cherries 200

Formula references Sales column in B2:B4.
The formula uses the Sales column values from cells B2 to B4 to calculate the total.
Result
   A        B        C
1 Product  Sales    Total Sales
2 Apples   100      450
3 Bananas  150
4 Cherries 200
The Total Sales measure shows the sum of all sales, 450, calculated by DAX.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the DAX formula SUM(Sales[Sales]) do?
AFinds the highest sales value
BAdds all sales values together
CCounts the number of sales entries
DCalculates the average sales
Key Result
SUM(column) adds all numbers in a column to produce a total.