Exam 70-778 topic 1 question 85 discussion

I think the ans should be C. If there is summarization set on Region then the visualization will show count of regions and not in an unsummarized fashion like the source data.

This sounds like semantics. It is the Sales column which is summarized, but it's summarized based on region. For that reason the answer is B.

The correct Answer is C

Ans is B if you create the table yourself, use table visualization and add region only, it will give you the same summary.

C is correct answer.

B seems to be right. "Summarization" indicates the usage of the "Summarize Function" prior to "Sum function" in the article: https://docs.microsoft.com/en-us/dax/summarize-function-dax is shown, that summarize includes a "groupBy" component which in our example works on the Region column. Logically I assume, that first the Default Summarization (Summarize Function) on Region and then the Sum of Sales is happening. Because if you would have 6 different row entries in Region column in Table 1 you would also have 6 rows in the Table 2.

my 1st reaction is B, but think deeply, should be C. It’s a English question. Usually we think this way, If in query mind, it must be “Group by” Region and then Aggregator is “Sum” Sales #. Here we go, we “sum” sales #. If in field list mind, we must put “region” in Row field, and put “Sales#” into Value field get a default summarization and it must be a auto sum. Here we go, we get “Sum” of Sales# again. From B perspective, if we put “Region” into value field, we get a auto “Count”….also display 4 rows, but we get CA:2, Italy:1, Spain:1, and US:2 .

Interesting but having looked into how 'SUMMARISATION' function works I'd go B - because you want to specify the column you want to summarise for to give the output - as mentioned pbia the summarisation of sale column by itself gives a total - for each row, the default is by Region - as per above format. SUMMARIZE(ResellerSales_USD , DateTime[CalendarYear] , ProductCategory[ProductCategoryName] , "Sales Amount (USD)", SUM(ResellerSales_USD[SalesAmount_USD]) , "Discount Amount (USD)", SUM(ResellerSales_USD[DiscountAmount]) )

The answer is C. This is an English question, sum sales up to get the answer

The summarization is happening on region ( same region) which is resulting on adding the sales amount and not other way round. Hence summarization on region is correct answer.

you cannot total a non numeric field, so summarizing the Country is not possible, you summarize the Sales, therefore C is the correct answer.

if default summarization of sales then value should be sum of all sales not by region, so it should be summarization by region

So this question is super confusing... I tested this and when I got in to the Values Pane to have a look at what's going on, keeping in mind that the question states "What causes the visualization to display four rows of data instead of six?" - assuming the visualization is a table visual... When I click on the drop down option for "Region" value the DON'T SUMMARIZE option is already ticked (with the green arrow) so when I go to click it again, nothing happens, the table remains the same as the one shown in the question... I clicked on all the other options and it looks nothing like the example. However, when I go to the "Sales" value drop down, the green arrow is actually on the SUM option and when I click the 'DON'T SUMMARIZE' option, all 6 rows appear in my visual... The answer makes no sense... I'm sorry but from tested I think the Answer is C because I've tried all the other options, even backwards with Region and it still doesn't show the same as the example.

Answer is C - the Default Summarization on Sales. By default the column aggregation for Sales will be SUM.

Is it an English Test? It should be summarised by Country on sales!

Correct answer is C , I tried

Correct answer is C.