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

QWhich DAX expression would most likely be used to calculate a percentage of total sales?

ID: #25397 Introduction to Power BI 2 views
Question Info
#25397Q 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 SUM(Sales[Amount]) ✔ ✖
  • B COUNTROWS(Sales) ✔ ✖
  • C DIVIDE(SUM(Sales[Amount]), CALCULATE(SUM(Sales[Amount]), ALL(Sales))) ✔ ✖
  • D DISTINCTCOUNT(Sales[Amount]) ✔ ✖
Correct Answer

Explanation

Option C is correct because it divides the current sales value by the overall sales value after removing filters using ALL(). This is a common pattern for calculating percentage contribution to the total. Option A returns only total sales. Option B counts rows rather than calculating percentages. Option D counts unique values and is unrelated to percentage-of-total calculations.
 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

What type of users commonly use Power BI? 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 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?