Power BI – Data Analytics & Visualization › Introduction to Power BI › Question #25389
Multiple Choice Difficult

QA report contains a measure: Total Sales = SUM(Sales[Amount]). A user applies a filter for Year = 2025. What will happen?

ID: #25389 Introduction to Power BI 2 views
Question Info
#25389Q ID
DifficultDifficulty
Introduction to Power BITopic
Start Quiz on This Topic
 Your Answer

Select All That Apply

Tick every correct option, then press Check Answer.

  • A The measure will calculate sales only for records matching the filter. ✔ ✖
  • B The measure will ignore the filter automatically. ✔ ✖
  • C The measure will return all years' sales. ✔ ✖
  • D The measure will stop working. ✔ ✖
Correct Answer

Explanation

Option A is correct because Measures are evaluated within the current filter context. When Year 2025 is selected, the SUM calculation will be performed only on records belonging to 2025. This dynamic behavior is a key difference between Measures and Calculated Columns. Options B, C, and D contradict how DAX measures work.
 Continue Practice
Previous Question Next Question
 Share

Share This Question

Challenge a friend or share with your study group.

 More from This Topic

Related MCQ Questions

Which of the following is a common use of Power BI? Why is data transformation important in Power BI? Which feature makes Power BI valuable for decision-making? What type of users commonly use Power BI? What is the primary purpose of Power BI? A report takes 20 seconds to load. Which Power BI tool should be used FIRST to identify which visuals or queri A Power BI developer notices that report performance is slow. The model contains many unnecessary columns that What is the primary purpose of an On-Premises Data Gateway? Which statement best describes filter context in DAX? Which scenario is MOST suitable for DirectQuery instead of Import Mode?