Bird
0
0

You created a measure with this formula:

medium📝 Formula Fix Q6 of 15
Power BI - Basics and Architecture
You created a measure with this formula:
Total Sales = SUM(Sales[Amount]
Why does Power BI show an error?
ASUM function cannot be used in measures
BMissing closing parenthesis
CColumn name is incorrect
DMeasure name cannot have spaces
Step-by-Step Solution
Solution:

  1. Step 1: Check DAX syntax carefully

    The formula is missing a closing parenthesis after Amount].

  2. Step 2: Identify syntax error cause

    Missing parenthesis causes Power BI to show a syntax error.

  3. Final Answer:

    Missing closing parenthesis -> Option B

  4. Quick Check:

    Syntax error = Missing parenthesis [OK]
Quick Trick: Always close all parentheses in DAX formulas [OK]
Common Mistakes:
  • Forgetting closing parenthesis
  • Wrong column name
  • Thinking spaces are not allowed in measure names

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Power BI Quizzes
Basic Visualizations - Pie and donut charts - Quiz 2easy Basic Visualizations - Bar and column charts - Quiz 11easy Basic Visualizations - Bar and column charts - Quiz 1easy Data Cleaning with Power Query - Handling null and blank values - Quiz 12easy Data Cleaning with Power Query - Trim and clean text - Quiz 10hard Power BI Basics and Architecture - Power BI Desktop vs Service vs Mobile - Quiz 14medium Power BI Basics and Architecture - Power BI installation and setup - Quiz 1easy Power Query Editor - Splitting and merging columns - Quiz 14medium Power Query Editor - Splitting and merging columns - Quiz 1easy Power Query Editor - Replace values - Quiz 3easy