Exam PL-300 topic 2 question 85 discussion

Actual exam question from Microsoft's PL-300

Question #: 64
Topic #: 2

You have a Power BI model that contains a table named Employees. The table contains the following columns:

• Employee ID
• First Name
• Last Name
• Department
• Salary

Each employee is uniquely identified by using Employee ID.

You need to create a DAX measure that will calculate the average salary of all the employees in the sales department.

Which DAX expression should you use?

A. DISTINCTCOUNT(‘Employees’[Salary])
B. CALCULATE(DISTINCTCOUNT(‘Employees’[Salary]), ‘Employees’[Department] = “Sales”)
C. CALCULATE(AVERAGE(‘Employees’[Salary]), ‘Employees’[Department] = “Sales”)
D. AVERAGE(‘Employees’[Salary])

Show Suggested Answer

Suggested Answer: C 🗳️

by INDEAVR at Feb. 28, 2024, 6:31 p.m.

Comments

Submit Cancel

jaume

7 months, 4 weeks ago

Selected Answer: C

DISTINCTCOUNT as in Option A is definitively not calculating any averge but just how many different salaries there are in the table Similar, option B is calculation how many different salaries there are in the "Sales" Deptm Option D is calculating the total salary average in the company not just for the "Sales" department (and it could be affected by CONTEXT filters) In option C we are calculating the AVERAGE of the Salary, just for employees in SALES department and encapsulating calculation in CALCULATE to remove any report filter

upvoted 4 times

...