Exam DA-100 topic 3 question 8 discussion

Total Sales is what we analyze,we explain by occupation and expand by city. correct

Why do we need city here? I dont see any word mentioning the analysis requirement on city

Does it matter city first or occupation first?

I got it on my exam 03/17/2022. 90-95% questions were from here. 61 questions in 100 min. All 3 case studies that appeared in exam, where from here.

on exam 02/22/2022

on exam 12/10/2021

Total Sales is what we analyze,we explain by occupation and expand by city. I agree wit this answer because there is City is only one which makes sense. It looks like there is no empty space option. Given the previous answers , somebody can give a clear definition of a measure or summarized column, I think here is the key point.

On exam 10/14/21

question in exam on 18th September

https://youtu.be/2X1cW8oPtc8

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers it makes sense to add city(expand by) for a more detailed analysis by geography.

Given the case only way to use Expand by City is when Total Sales is a measure, given question do not clarify it I will go by City only option left.

can anyone please say whether expand by should be occupation or should be left blanked?

This question was in the exam.

Total Sales is what we analyze,we explain by occupation and expand by city. You can use Expand By to add fields you want to use for setting the level of the analysis without looking for new influencers. https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

Metric you want to investigate into the Analyze field: Here we want to check what drives Total Sale Explain by field : Move fields that you think might influence Rating into the . We want to check how Occupation drive Total Sale Expand by: This field is only used when analyzing a measure or summarized field. Is City is measure or summarized field? No. So it should be empty ref: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers#analyze-a-metric-that-is-categorical

I also saw that after test in test when you want to add a field to "expanded by " , Power BI say the field added in the " Analyze box" (Total Sales here) is not measure or not summarized. but when you summarize the field you can added after a field in the "expand box" ------------------------------------------------------ not sur about "city" in the "expand box"