I have the isseu that I want to create a relation ship, however I can not make this relation ship active because there are other relations that obstruct.
I would like to share a sample pbix with you, but I don't know how to do this.
So I will try explain it:
I have the following tables:
Active single relationships:
- 'table 1' (representative) and 'table 3' (customer list)
- 'table 3' (customer list) and 'table 2' (visit list)
And I want to create something like the following report page:
The map will show the customers and the linked visit notes.
In the bar chart on the top of the page I would like to count all visit reports per reason of visit, however some of these visit reports are with potential customers and do not have a customer code yet.
So I would like to make a bar chart that counts all visit reports per reason of visit. And a map that only shows the customers that have a customer code and is linked with the visit notes.
I hope this explanation is clear enough, but please ask if more information is needed.
Generally, you can share a PBIX file using OneDrive or Box or other cloud-based storage. Often, you can fix relationship issues through counseling. However, that's never worked for me personally and hence the two divorces. So, if that doesn't work, you can try chaning relationships from bi-directional to uni-directional. If that will not work, then use the USERELATIONSHIP function.