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])








 

Suggested Answer: C



This question is in PL-300 Exam
For getting Microsoft Power BI Data Analyst Associate Certificate