Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 124 discussion

Actual exam question from Microsoft's 70-778

Question #: 124
Topic #: 1

HOTSPOT -
You have a Power BI model that has 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)
You plan to create the following measure.
Measure1 = DISTINCTCOUNT(Sales[ProductID])
You need to create the following relationships:
✑ Sales to Product
✑ Sales to Salesperson
The solution must ensure that you can use Measure1 to display the count of products sold by each salesperson.
How should you configure the relationships? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

by exam_taker5 at July 10, 2019, 9:27 p.m.

Comments

Submit Cancel

RJM9000

4 years, 10 months ago

"Single" filter is the right choice, the filters always propagate from one-side to many-side, in "many to one relationship" also.

upvoted 2 times

...

Jony

5 years ago

Single direction is correct. The measure is counting Sales[ProductID] column in sales table - NOT in product table. Furthermore, it would not make sense to do a DISTINCTCOUNT on a ID column if it had been the product table.

upvoted 4 times

...

exam_taker5

5 years, 11 months ago

Couldn't a cross filter direction of 'both' also work?

upvoted 3 times

SteveKarr

5 years, 10 months ago

Both will also work but required in this case

upvoted 3 times

...

Hien

5 years, 9 months ago

must be Both

upvoted 8 times

...

Brunobsv

5 years, 7 months ago

In my opinion single it's right because the measure is created in the Sales Table, which by the relationships created (*;1) is filtering the other two tables, so no need for the both.

upvoted 23 times

CorinnaK

5 years, 7 months ago

yes, that's definitly the point. It depends where the measure is created. So in this case there is no need for "both"

upvoted 13 times

...

Ricky7876

5 years, 3 months ago

Agreed - No need for both, but there is a similar question that states that the relationships are already established and states that you should make a change in order for the measure to work. I think that question is wrong... In this situation the measure is counting the rows in the Sales table. The Sales table acts as a Fact table and the other tables are dimensions. With One-To-Many, single relationships there isn't an issue in filtering that measure with both dimensions.

upvoted 2 times

RutRut

5 years, 3 months ago

You count Sales[ProductID]. Sales is on MANY side of relationships, dimensions (Product and Salesperson) are on the ONE side of each relationships. Question is about relationship Sales to Dims, so MANY-to-ONEis correct. Filters could be Single, only if you had to count products sold, shown by id's. When you choose Product_Name, Salesperson_Name and measure within one visual you have to change filter to BOTH, beacuse dimensions should filter each other.

upvoted 2 times

RutRut

5 years, 3 months ago

correction, using SINGLE also works well

upvoted 3 times

...

amar111

5 years, 1 month ago

Measure is created at report level . Answer "Single" is CORRECT , because measure created use PRODID column from Sales table . So filter context starting from SalesPerson table does not have to go beyond Sales table . The Filter Context can easily find PRODID's from sales table with * - 1 relation and single cross filter direction

upvoted 2 times

...

Load full discussion...

...