Power BI - Basics and Architecture
Given a Power BI report with a sales table, what will the measure below calculate?
Total Sales = SUM(Sales[Amount])
Given a Power BI report with a sales table, what will the measure below calculate?
medium📝 dax lod result Q4 of 15
Step-by-Step Solution
Solution:
Step 1: Understand the DAX function SUM
SUM adds all values in the specified column, here Sales[Amount].Step 2: Interpret the measure
This measure totals all sales amounts, not counting transactions or averaging.Final Answer:
The sum of all sales amounts -> Option DQuick Check:
SUM function = Total sales amount [OK]
Quick Trick: SUM adds all values in a column [OK]
Common Mistakes:
- Confusing SUM with COUNT or AVERAGE
- Thinking it counts transactions
- Assuming it finds max value
Master "Basics and Architecture" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes