Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I'm a bit stuck right now. I'm sure there's an easy solution, but it's evading me right now.
I'm trying to connect two tables with a relationship on customerid. I want to basically create a filter using this column.
Solved! Go to Solution.
Sorry, that was really a messy explaination. For further clarification, I have the following 3 tables:
ClientTable
CustomerID | Name | Primary Staff |
1 | Jack | Adam |
2 | John | Alex |
3 | Joan | Adam |
4 | Jill | Alex |
Appointment Table
CustomerID | AppointmentDate | ApointmentStaff | ApptDesription |
1 | 1/1/2019 | Adam | OTHER |
1 | 2/1/2019 | Aubree | SAL |
2 | 3/1/2019 | Alex | OTHER |
3 | 1/1/2019 | Aubree | SAL |
3 | 2/1/2019 | Aubree | SAL |
3 | 3/1/2019 | Adam | OTHER |
SALs Table
CustomerID | DateofService(AppointmentDate) | CPTCode | SALStaff |
1 | 2/1/2019 | NOBIL | Aubree |
3 | 1/1/2019 | NOBIL | Aubree |
3 | 2/1/2019 | 1234 | Aubree |
I would like to make sure that all views of tables are related. So when I click on the 2nd row in the Sals table, the only option that shows up in the client table is Joan and the 4th row on the appointment table.
Right now, when I click on the second row in the SALs table, nothing is dynamically filtered on the client table. My relationships are currently all based on ClientID.
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |