اضغط هنا للانضمام الى قروب فوجي للإختبارات على تيليقرام

اختبار شهادة مايكروسوفت Microsoft Power BI Data Analyst

السؤال 38 من 50

كل الأسئلة

You have a semantic 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 CALCULATE(DISTINCTCOUNT('Employees'[Salary]), 'Employees'[Department] = "Sales")
  • B AVERAGE('Employees'[Salary])
  • C DISTINCTCOUNT('Employees'[Salary])
  • D CALCULATE(AVERAGE('Employees'[Salary]), 'Employees'[Department] = "Sales")

النقاشات

لا توجد نقاشات منشورة لهذا السؤال حالياً.