Reply
Frequent Visitor
Posts: 2
Registered: ‎02-13-2017

Lab 2 Exercise 1 Manage Table Relationships

Hi,

 

I just finished the Lab 2 Exercise 1, and realized that the answer of 2nd question (what is the cross filter direction of the relationship?) shall be "Single" not "Both". The provided answer was wrong.

 

Referring to the "Creating calculated columns" Video in "Data Modelling in Power BI Desktop" section, the result was also "single".

 

Could anyone let me know your answer to this question? Thanks

 

Member
Posts: 93
Registered: ‎03-10-2016

Re: Lab 2 Exercise 1 Manage Table Relationships

The question answer is right, you will get correct result if you follow the steps

Occasional Visitor
Posts: 1
Registered: ‎01-23-2017

Re: Lab 2 Exercise 1 Manage Table Relationships

In the first list, Steps 3 - 5 specify ensuring that the first three relationships have Both cross directional filtering. However, in the second list, Step 6 reads only "Link the newly created CountryZip column on the Sales table to the newly created CountryZip column on the Locations table." Nowhere in the instructions does it specify changing the default filtering direction, which is Single.

Highlighted
Member
Posts: 93
Registered: ‎03-10-2016

Re: Lab 2 Exercise 1 Manage Table Relationships

You can double click the link line between Sales Tabel and Locations Table. You will see the result.