Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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.
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.
Thank you so much! I need to spend more time educating myself on modeling. Very much appreciate your help.
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |