Forum Discussion
Build a table relationship using OR
I have a table of services, a table of clients, and a table of contacts. My contacts are joined either to the client table OR the service table. I'm trying to figure out how to build this relationship in Power BI.
service to client is a one to one relationship
client to contacts is a one to many relationship
service to contacts is a one to many relationship
Here's a stripped down version of the tables:
| Services | ||
| service_seq | Service Type | client_seq |
| 111 | aaa | 999 |
| 222 | bbb | 888 |
| 333 | aaa | 777 |
| Client | ||
| client_seq | client name | client address |
| 111 | Mr. A | B street |
| 222 | Mr. B | C street |
| 333 | Mrs. C | D street |
| Contact | ||
| service_seq | client_seq | contact info |
| 111 | Dr. A | |
| 888 | Dr. B | |
| 222 | Dr. C | |
| 222 | Dr. D | |
| 777 | Dr. E |
Any thoughts?
1 Reply
Rjesak ,
Join the contract with both.
And keep Service and client relation inactive. Activate in the formula as per need. Using userelation. Also deactivate a relation with contract using crossfilter
