Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Hot Area / Sentence Completion
Select the appropriate option to complete the statement. Click Check Answer below to see the marked solution.
Hotspot Solution:
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
* Answer: - two explicit measures - Summarization setting * Explanation: 1. two explicit measures - In the visual, we see two implicit measures: Sum of Sales Amount Sum of Product Cost - Therefore, to replace them, we need two explicit measures. 2. Summarization setting - Aggregation behavior (Sum, Average, Min, Max, etc.) is controlled by the Summarization setting in Power BI. - Data category and data type affect formatting and interpretation, not aggregation. - DAX expression would only apply if we explicitly wrote a measure, but the question is about changing the default aggregation of a field.
Must be summarization setting. This is an implicit measure not an explicit one. It is geberated by Power BI itself, and can only be modified by summarization setting.
SUM icon on the left side of the field means the field is summarized (can be COUNT, SUM, AVERAGE...) and turning the IMPLICIT into EXPLICIT would affect the TWO measures. What does "...in additional visuals" mean? keeping visual as in the exhibit but adding new visuals? Whatever, you can still use same fields in additional visuals and change summarization on the specific visual using the "Summarization Setting" available on the "Visualizations" pane (within the Y-Axis in the exhibit for this visual)