Forum Discussion
Relationship Problems
Good afternoon all: I have a series of tables between which I am trying to manage relationships. These five tables have several columns that have entries between them that are the same and on an ...
Hi stevejpage
I had a look and the issue was that the Calculated Table was not including all the related tables.
So if you can see below I modified it to include another table
AllSiteAccessProfileID = FILTER(DISTINCT(UNION( DISTINCT(GroupSiteAccessProfileWithcriti[Site Access Profile ID]), DISTINCT(GroupSiteAccessProfileWithreque[Site Access Profile ID]) )), (not(isblank([Site Access Profile ID]))))
And what you will need to do, is to add any additional table.
Then you will need to create the relationships as I did between the two tables above.
Which once done you can then have all the data related as shown below. NOTE: In order for the relationships to work you have to put in a measure.
And finally here is a link to your original PBIX file with the above changes added.
This is probably as good as it's going to get, and the part that I was missing was the requirement to have a measure included. It's not the way I had envisioned it, preferring to have something like this be the result (when filtered down). I'd like to be able to create an additional Matrix chart which will allow us to visualize the Security Groups by color, and within that, see the Site Access Profiles.
| Security Group | Site Access Profile ID | Site Access Profile Alias | List of Valid Sites | List of Requested Sites | List of Critical Sites |
| PASADENA | 33 | PPD Dispatch Roam | Bev Hills P25 | Pasadena | Pasadena |
| Glendale P25 | |||||
| Hauser Peak | |||||
| Montebello | |||||
| Oat Nike P25 | |||||
| Pasadena | |||||
| Pomona PD |
Maybe I'm asking for something that isn't available yet, but in a future release (or when I learn more about DAX), we'll get what we are looking for.
In the meanwhile I appreciate the help, and will continue learning.
Thanks