cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Nz2017 Frequent Visitor
Frequent Visitor

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

 

14 REPLIES 14

Re: Lab 2 Exercise 1 Manage Table Relationships

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

Neurokraft Visitor
Visitor

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.

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.

sushkanchi Frequent Visitor
Frequent Visitor

Re: Lab 2 Exercise 1 Manage Table Relationships

I followed the steps as well and by default I got SINGLE as the cross filter direction.

Can you let me know where I went wrong?

Also wile creating a relationship from Date column in Sales table to Date column in Date table the default cross direction filter obtained was SINGLE. I changed it manually to BOTH as instructed in the lab.

sushkanchi Frequent Visitor
Frequent Visitor

Re: Lab 2 Exercise 1 Manage Table Relationships

Hi I followed the same steps and also got SINGLE as the default Cross direction filter.

Please let me know where I went wrong.

Also after creating many to one relationship between Sales[Date] and Date[Date] I got SINGLE as the default Cross direction filter,

I then changed it to BOTH as per the instructions.

Re: Lab 2 Exercise 1 Manage Table Relationships

It is worked for me, could you provide your result to us?

 

KimHeadrick Visitor
Visitor

Re: Lab 2 Exercise 1 Manage Table Relationships

I too got single but changed it to get the question correct. I saved a screen shot if you need to see it.

 

TheKemist Frequent Visitor
Frequent Visitor

Re: Lab 2 Exercise 1 Manage Table Relationships

I've just had the same issue. After creating the relationship the Cross Filter Direction was "Single", I had to manually change this to "Both". 

 

If you follow the directions on the lab instructions you end up with the incorrect answer.

ricardo-hunda Frequent Visitor
Frequent Visitor

Re: Lab 2 Exercise 1 Manage Table Relationships

I did the exact same thing, so at the end of the day what is the correct answer? Single or both? 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 290 members 2,818 guests
Please welcome our newest community members: