How to lookup the value from another table

[hemingt]

Hello Team,

I have two tables in my source data, one table have records about test assignees and the realted tests status.

the other table have the infomation about the test assignee, such as Team.

I have the below chart, I want to use the Team slicer to those assignees belong to selected Team.

Could you help me? thanks a lot!

 

[v-chuncz-msft · Accepted solution]

@hemingt ,

You may just add relationship or use RELATED and LOOKUPVALUE to add a calculated column.

[hemingt]

got it. thank you! 

[hemingt]

Is there any suggestion? Thank you!