Exam 70-778 topic 1 question 30 discussion

Actual exam question from Microsoft's 70-778

Question #: 30
Topic #: 1

You have two tables named CustomerVisits and Date in a Power BI model.
You create a measure to calculate the number of customer visits. You use the measure in the report shown in the exhibit. (Click the Exhibit button.)

You discover that the total number of customer visits was 60,000, and that there were only 5,000 customer visits in August.
You need to fix the report to display the correct data for each month.
What should you do?

A. Modify the measure to use the CALCULATE DAX function.
B. Create a relationship between the CustomerVisits table and the Date table.
C. Modify the measure to use the sum DAX function.
D. Create a hierarchy in the Date table.

Show Suggested Answer

Suggested Answer: B 🗳️
References:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures

by Echicken07 at March 5, 2020, 3:58 a.m.

Comments

Submit Cancel

Echicken07

Highly Voted 5 years, 2 months ago

You will have to look at the Schema on the relationships because it seems like it's adding not calculating the values.

upvoted 6 times

...

Galven6

Most Recent 4 years, 4 months ago

B is correct.

upvoted 1 times

...

Nmak

4 years, 8 months ago

Usually when the Question is provided , if the relationship exists it is mentioned. So If it is not mentioned in the question then its understood that the Aggregation is happening for all Months. and showing 60000 for each month.

upvoted 3 times

...

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 30 discussion

Comments

Echicken07

Galven6

Nmak

SY0-701