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

QWhat is the primary purpose of the ALL() function in DAX?

ID: #25396 Introduction to Power BI 2 views
Question Info
#25396Q 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 To create relationships between tables. ✔ ✖
  • B To remove filters from specified tables or columns. ✔ ✖
  • C To count all rows in a table. ✔ ✖
  • D To return all reports in a workspace. ✔ ✖
Correct Answer

Explanation

Option B is correct because ALL() removes filters from a table or column and is commonly used when calculating percentages, grand totals, or comparisons against overall totals. For example, it can calculate Total Sales regardless of the currently selected region. Option A is unrelated to DAX. Option C describes counting functionality. Option D is unrelated to Power BI 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

Why is data transformation important in Power BI? What type of users commonly use Power BI? Which of the following is a common use of Power BI? What does a KPI visual typically show? Which feature makes Power BI valuable for decision-making? Which company developed 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 What is the primary benefit of Incremental Refresh? Why might a Power BI developer use USERELATIONSHIP() in DAX?