[Solved] You wrote this DAX measure but get an error:Total Sales = SUM(Sales Amount)What is the likely cause? | Power BI

Power BI - Basics and Architecture

You wrote this DAX measure but get an error:

Total Sales = SUM(Sales Amount)

What is the likely cause?

ATable name is incorrect

BSUM cannot be used in measures

CMissing square brackets around column name

DMeasure name cannot have spaces

Step-by-Step Solution

Solution:

Step 1: Check DAX syntax for column references
Column names must be enclosed in square brackets, e.g., [Sales Amount].
Step 2: Identify the error cause
Missing brackets cause syntax errors. SUM is valid, table name is not shown, and measure names can have spaces.
Final Answer:
Missing square brackets around column name -> Option C
Quick Check:
Column reference syntax = Use brackets [OK]

Quick Trick: Always use [ ] around column names in DAX [OK]

Common Mistakes:

Master "Basics and Architecture" in Power BI

9 interactive learning modes - each teaches the same concept differently

More Power BI Quizzes

You wrote this DAX measure but get an error: