Microsoft Certified Power Bi Data Analyst Associate · Free Practice Question Medium
Question 14
This question is part of repeated scenario questions that contain the same stem but with a different solution for each question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario questions might contain either none, one, or many solutions.
Below is a Power BI Column chart that displays the Total Marks obtained by 15 Grade X students in Marion Cross School.
You need to create a reference line that shows which students are above/below the median class marks.
Solution: You create an average line using the Total Marks measure.
Does the solution meet the goal?
-
A
Yes
-
B
No
Reveal correct answer
Correct answer: B
Explanation
Average and median are different concepts. For a set of three values, 1, 5, 12 :
· 5 is the median (the middle value),
· And 6 is the average (1+5+12)/3.
Creating an average line will NOT show which students are above/below the median class marks. Option No is the correct choice.
Note: The average for this dataset is 336. Whereas, the median will pass through 280.
Reference Link: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane#use-the-analytics-pane
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
