Practice - 5 Tasks
Answer the questions below
1fill in blank
easyComplete the code to create a measure that sums sales.
Power BI
Total Sales = SUM([1]) Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Choosing a non-numeric column like date or name.
✗ Incorrect
The SUM function adds all values in the Sales Amount column.
2fill in blank
mediumComplete the code to filter sales for the year 2023.
Power BI
Sales 2023 = CALCULATE(SUM(Sales[Amount]), Sales[Year] = [1])
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using a wrong year or a string instead of a number.
✗ Incorrect
The filter keeps only sales where the year is 2023.
3fill in blank
hardFix the error in the measure to calculate average sales.
Power BI
Average Sales = AVERAGE([1]) Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using non-numeric columns causes errors.
✗ Incorrect
The AVERAGE function requires a numeric column like Sales Amount.
4fill in blank
hardFill both blanks to create a filter for products priced above 100.
Power BI
High Price Sales = CALCULATE(SUM(Sales[Amount]), Products[Price] [1] [2])
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using less than or wrong numbers.
✗ Incorrect
The filter uses > 100 to select products priced above 100.
5fill in blank
hardFill all three blanks to create a measure that counts customers from USA.
Power BI
USA Customers = CALCULATE(COUNT([1]), Customers[Country] [2] [3])
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Counting names or using wrong comparison operators.
✗ Incorrect
The measure counts customer IDs where Country equals "USA".