Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Probably could use USERELATIONSHIP, see article here:
https://msdn.microsoft.com/en-us/library/hh230952.aspx
You could create a measure like:
Measure = CALCULATE(COUNT('Visit list'[Visit date]),USERELATIONSHIP('Representative list'[Representative],'Visit list'[Representative]))
Also, I may be incorrect but it would appear to me that you could just remove the relationships between 'Representative list' and 'Customer list' and your filtering should flow through.
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.
Thank you for your reply.
Tried counseling, but did not work.
All my relation ships are uni-directional:
Can you elaborate on the USERELATIONSHIP function?
Now the count bar chart in my previous post only counts the visits which have a customer code, because of the active relationships. I want to let it count all visit reports per representative.
Can this be done with USERELATIONSHIP?
Probably could use USERELATIONSHIP, see article here:
https://msdn.microsoft.com/en-us/library/hh230952.aspx
You could create a measure like:
Measure = CALCULATE(COUNT('Visit list'[Visit date]),USERELATIONSHIP('Representative list'[Representative],'Visit list'[Representative]))
Also, I may be incorrect but it would appear to me that you could just remove the relationships between 'Representative list' and 'Customer list' and your filtering should flow through.
Thank you very much for the measure. It works!
Of course I can delete the other relationships, however this was only a samle report. In my report I have other things that require that relationship.
Ah, got it. Glad it works!
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
73 | |
60 | |
58 |