SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-3217233%22%20slang%3D%22en-US%22%3EProblem%20with%20Power%20BI%20Learning%20Collection%20Lab%20-%20Model%20data%20in%20Power%20BI%20Desktop%2C%20Part%202%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217233%22%20slang%3D%22en-US%22%3E%3CP%3EProblematic%20lab%3F%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Flearn%2Fmodules%2Fdesign-model-power-bi%2F9-lab%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Flearn%2Fmodules%2Fdesign-model-power-bi%2F9-lab%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20attempted%20this%20lab%20several%20times%20and%20can't%20seem%20to%20get%20the%20correct%20result%20in%20Task%202%2C%20Step%2019%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20feel%20like%20I've%20followed%20every%20step%20exactly.%20What%20subtle%20thing%20am%20I%20missing%20in%20order%20to%20get%20the%20expected%20result%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EHere's%20my%20data%20model%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%221%20-%20My%20Data%20Model.PNG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F351459i39D47FD4A397AD6F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%221%20-%20My%20Data%20Model.PNG%22%20alt%3D%221%20-%20My%20Data%20Model.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EThe%20salesperson%20region%20relationship%20information%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222%20-%20The%20Region%20relationship.PNG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F351460i2907DA3D00C74466%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%222%20-%20The%20Region%20relationship.PNG%22%20alt%3D%222%20-%20The%20Region%20relationship.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EThe%20Salesperson%20relationship%20configuration%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%223%20-%20The%20Salesperson%20Relationship.PNG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F351461iA1DB9BED12C3973C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%223%20-%20The%20Salesperson%20Relationship.PNG%22%20alt%3D%223%20-%20The%20Salesperson%20Relationship.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EThe%20lack%20of%20expected%20result%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%224%20-%20Unexpected%20Result.PNG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F351462iC7AD2E7F8BC961F9%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%224%20-%20Unexpected%20Result.PNG%22%20alt%3D%224%20-%20Unexpected%20Result.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3217233%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPower%20Platform%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESelf-paced%20learning%20path%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3219772%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Power%20BI%20Learning%20Collection%20Lab%20-%20Model%20data%20in%20Power%20BI%20Desktop%2C%20Part%202%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3219772%22%20slang%3D%22en-US%22%3Eany%20chance%20of%20a%20hand%20here%3F%20i'd%20prefer%20not%20to%20skip%20the%20lab%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3220368%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Power%20BI%20Learning%20Collection%20Lab%20-%20Model%20data%20in%20Power%20BI%20Desktop%2C%20Part%202%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3220368%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1318762%22%20target%3D%22_blank%22%3E%40Rosemary_Ingrey%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20had%20done%20this%20exercise%20last%20year%20and%20it%20seems%20to%20be%20working%20fine.%20I%20have%20attached%20expected%20data%20model%20screenshot%2C%20hopefully%20this%20helps.%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MS%20Learn%201.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F351691iD75C2990AADB056E%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22MS%20Learn%201.png%22%20alt%3D%22MS%20Learn%201.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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 (Occasional 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 :)