SOLVED

Problem with Power BI Learning Collection Lab - Model data in Power BI Desktop, Part 2

Copper Contributor

Problematic lab? https://docs.microsoft.com/en-us/learn/modules/design-model-power-bi/9-lab

 

I've attempted this lab several times and can't seem to get the correct result in Task 2, Step 19

 

I feel like I've followed every step exactly. What subtle thing am I missing in order to get the expected result?

 

Here's my data model

1 - My Data Model.PNG

 

The salesperson region relationship information

2 - The Region relationship.PNG

 

The Salesperson relationship configuration

 

3 - The Salesperson Relationship.PNG

The lack of expected result:

 

4 - Unexpected Result.PNG

3 Replies
any chance of a hand here? i'd prefer not to skip the lab
best response confirmed by Rosemary (Copper Contributor)
Solution

@Rosemary 

I had done this exercise last year and it seems to be working fine. I have attached expected data model screenshot, hopefully this helps. MS Learn 1.png

ahaha thanks yes I can spot my error straight away. i'll have another go now, thank you :)
1 best response

Accepted Solutions
best response confirmed by Rosemary (Copper Contributor)
Solution

@Rosemary 

I had done this exercise last year and it seems to be working fine. I have attached expected data model screenshot, hopefully this helps. MS Learn 1.png

View solution in original post