PL-300 Question 134

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose C1

  * Answer: C. CALCULATE(AVERAGE(‘Employees’[Salary]), ‘Employees’[Department] = “Sales”) - This calculates the average salary, but only for rows where Department = "Sales". Exactly what’s required. * Why not the others: A. DISTINCTCOUNT(‘Employees’[Salary]) - This counts the number of unique salary values, not the average salary. B. CALCULATE(DISTINCTCOUNT(‘Employees’[Salary]), ‘Employees’[Department] = “Sales”) - Same issue: it counts distinct salary values, not the average. Adding the filter doesn’t change that. D. AVERAGE(‘Employees’[Salary]) - This gives the average salary across all employees, not just Sales.

• Chose C4

  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

• 4

  C is the correct answer.