Need help with LOOKUPVALUE and displaying results based on 3 different Tables

[phantomias33]

I have three tables, essentially:

Weekly Staffing Table

Site Name	Country
Hamburg	Germany
Dubai	U.A.E.
Hannover	Germany
Galway	Ireland

Country Risk Level Table

Country Name	Risk Level
Germany	Low
U.A.E.	Moderate
Ireland	Low

Current Roster Table

Site Name	Employee Name
Hamburg	Dirk Nowitski
Hamburg	Angela Merkel
Hannover	Otto Waalkes
Hannover	Emil Berliner
Hannover	Georg Haendel
Dubai	Mohammed Omar
Dubai	Ali Saleh
Galway	Paul King

I've modeled a one-to-many relationship from 'Country' to 'Country Name' in the first two tables.  What I'd like to do is use a visual (possibly a table visual) to then show all the Employees in a particular country based on a slicer that selects the Risk Level of that country from the second table.

Using Copilot to ask this question, it pointed me down the road of using LOOKUPVALUE but I can't get it to work.  Any help or pointers would be greatly appreciated.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your expected outcome looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file whether it suits your requirement.

[Ritaf1983 · Accepted solution]

Hi @phantomias33 
According to the description is a basic model + drag and drop :

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[phantomias33]

Thank you so much!  I need to spend more time educating myself on modeling. Very much appreciate your help.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your expected outcome looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file whether it suits your requirement.

[phantomias33]

Thank you for taking the time to answer.  Copilot can be a great help but it can't replace the help from experts like yourself.  Really appreciate your assistance.