ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam
Go to Exam

Exam 70-778 topic 1 question 26 discussion

Actual exam question from Microsoft's 70-778
Question #: 26
Topic #: 1
[All 70-778 Questions]

You have a Microsoft Excel 2016 workbook that has a Power Pivot model. The model contains the following tables:
✑ Product (Product_id, Product_Name)
✑ Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount)
✑ Salesperson (Salesperson_id, Salesperson_name, address)
The model has the following relationships:
✑ Sales to Product
✑ Sales to Salesperson
You create a new Power BI file and import the Power Pivot model.
You need to ensure that you can generate a report that displays the count of products sold by each salesperson.
What should you do before you create the report?

  • A. Create a one-to-one relationship between Product and Salesperson.
  • B. For each relationship, change the Cross filter direction to Both.
  • C. For each relationship, change the Cardinality to One to one (1:1).
  • D. Change a many-to-one relationship between Product and Salesperson.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
References:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
by RBY10 at Sept. 6, 2019, 10:08 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Brunobsv
Highly Voted 5 years, 5 months ago
Their's no need to create another relationship, the model already has one that extends to the needed level. You know only need to allow the Sales table to filter Product an you can do that by changing the cross filter to both.
upvoted 22 times
kilowd
5 years, 3 months ago
Correct ..Currently Sales cannot filter products , therefore changing the cross filter to both allows the filter to go all the way to products
upvoted 4 times
...
...
AnetaK
Highly Voted 5 years, 5 months ago
We don't need a Product table at all. Just count the [Sales].[ProductId].
upvoted 13 times
Ricky7876
5 years, 2 months ago
Agreed... I don't think you need to do anything other than create the measure
upvoted 4 times
...
cromastro
4 years, 8 months ago
If you want SalesPerson, Product, Count() ... You most likely will not use ProductID. You most likely want to use the name of the Product. You need the cross-filter direction both to have a usable report.
upvoted 2 times
...
Lhouss
4 years, 5 months ago
Yes agree but we need a valid answer for the exam question which should be only B ;)
upvoted 2 times
...
...
CristianoMoraes
Most Recent 4 years, 5 months ago
In fact, you don't need to change anything. Just create a measure COUNT([Sales].[ProductId]) and keep normal 1-* relationships! But, You have to change to CrossFilter=BOTH, between Sales and Product tables, if you create a mesure COUNT([Product].[ProductId]) Only possible answer is B.
upvoted 2 times
...
SpecterBI
4 years, 6 months ago
Actually nothing is required to be done. Since we need a Count of Units sold by Product and Sales person. Simply putting them in a matrix would do the trick with the existing model
upvoted 1 times
...
CDL
4 years, 6 months ago
B is correct. same question as Q21. (1) Cross filter function (read the example): https://docs.microsoft.com/en-us/dax/crossfilter-function (2) Many to many relationship (read the example: composite model): https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models Ref Example Video: https://www.youtube.com/watch?v=44JKwL3Js10
upvoted 2 times
...
Martin_Nbg
4 years, 8 months ago
Actually, the requirement is unclear: Should we count how many different products are sold, or the quantity of all pieces sold, or the quantity of pieces sold by product. But luckily all other answers are so nonsense that this does not matter.
upvoted 1 times
...
kanchanpb
4 years, 9 months ago
I think for the current question u dont need to change anything.
upvoted 2 times
...
RBY10
5 years, 8 months ago
Should be just Product & Person a one to many relation with filter direction to Sales, isn't it?
upvoted 1 times
mirzotti
5 years, 6 months ago
Sales table is between Product table and SalesPerson table
upvoted 2 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago