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.
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?
@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
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 |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |