Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
47 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |