Question 76

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a percentile line by using the Salary measure and set the percentile to 50%.
Does this meet the goal?
  • Question 77

    You need to create a measure that will return the percentage of late orders.
    How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 78

    You need to grant access to the business unit analysts.
    What should you configure? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 79

    You have a Power Bl report that contains a measure named Total Sales.
    You need to create a new measure that will return the sum of Total Sates for a year up to a selected date. How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 80

    You have the dashboard shown in the following exhibit.

    You need to modify the dashboard to display as shown in the following exhibit.

    What should you do?