Exam PL-300 topic 2 question 84 discussion

- Two explicit measures - Summarization setting

The correct answer is : - 2 explicit measures - Summarization setting

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)

The given answer is incorrect... I have put - 2 measures - Summarization setting

- one explicit measure - summarization settings explanation: from the visual, there is only one implicit measure that can be replaced which is the 'sum of sales amount'. the 'sum of product cost' is not an implicit measure because the cost of individual products cannot be aggregated, hence, there is no such thing as 'sum of product cost'. It is only a wrong guess by power bi. what power bi does is that whenever a table is loaded into the model, it goes through each column of the table and make a guess of their data types. whenever it sees numeric columns such as date, product cost, and sales amount, it assumes that they are aggregable and automatically creates implicit measures for those columns by adding the summation sign next to those columns as shown in the example. To mitigate this weakness, developers have to manually go through each numeric column in their data model and change the summarization settings for non-aggregable columns just as part B of this question is suggesting. Thanks, Shalom!

Will changing the "Summarization setting" impact additional visuals as well? I thought it would only impact the current visual.

- Two explicit measures - Summarization setting

- Two explicit measures - Summarization setting

two explicit measures Summarization setting

Two explicit measures & summarization settings (if used as implicit measure as on the visual)