What is the purpose of a calculation group in Power BI?

To group related tables in the data model

To manage row-level security for multiple roles

To create calculated tables from a group of measures

To apply consistent calculations across multiple measures

A company has a Sales table with columns: OrderID, ProductID, Quantity, and UnitPrice. The company wants a measure that calculates total revenue by multiplying Quantity by UnitPrice for each order and then summing the results. Which DAX expression should you use?

CALCULATE(SUM(Sales[Quantity]) * SUM(Sales[UnitPrice]))

SUM(Sales[Quantity] * Sales[UnitPrice])

SUM(Sales[Quantity]) * AVERAGE(Sales[UnitPrice])

SUMX(Sales, Sales[Quantity] * Sales[UnitPrice])

A company has an Orders table with columns: OrderID, CustomerID, and OrderAmount. The company wants a measure that counts the number of unique customers who have placed at least one order. Which DAX expression should you use?

CALCULATE(COUNT(Orders[CustomerID]), DISTINCT(Orders[CustomerID]))

DISTINCTCOUNT(Orders[CustomerID])

Microsoft Certified:Power BI Data Analyst Associate

Domain 2Objective 2

Create Model Calculations by Using DAX PL-300 Practice Questions (Page 5)

Part of the Model the data domain, which accounts for 25–30% of the PL-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~10–20 in this domain), expect 3–7 from this objective — we provide 25 practice questions to prepare you well beyond it. (estimate)

25questions here

5free pages

8concepts

25–30%of the exam

Questions 21–25

21foundation · easy
What is the purpose of a calculation group in Power BI?
Select an answer first
22application · easy
A company has a Sales table with columns: OrderID, ProductID, Quantity, and UnitPrice. The company wants a measure that calculates total revenue by multiplying Quantity by UnitPrice for each order and then summing the results. Which DAX expression should you use?
Select an answer first
23foundation · easy
You are creating a measure to calculate the total sales amount from the Sales table. Which DAX function should you use?
Select an answer first
24foundation · easy
Which DAX function shifts dates by a specified number of intervals (such as days, months, or years) for time intelligence calculations?
Select an answer first
25application · easy
A company has an Orders table with columns: OrderID, CustomerID, and OrderAmount. The company wants a measure that counts the number of unique customers who have placed at least one order. Which DAX expression should you use?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to PL-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “PL-300” is a trademark of its owner, used for identification only.

Create Model Calculations by Using DAX PL-300 Practice Questions (Page 5)

Questions 21–25

What is the purpose of a calculation group in Power BI?

A company has a Sales table with columns: OrderID, ProductID, Quantity, and UnitPrice. The company wants a measure that calculates total revenue by multiplying Quantity by UnitPrice for each order and then summing the results. Which DAX expression should you use?

You are creating a measure to calculate the total sales amount from the Sales table. Which DAX function should you use?

Which DAX function shifts dates by a specified number of intervals (such as days, months, or years) for time intelligence calculations?

A company has an Orders table with columns: OrderID, CustomerID, and OrderAmount. The company wants a measure that counts the number of unique customers who have placed at least one order. Which DAX expression should you use?

Keep studying — Model the data