Forum Discussion
Relationship Problems
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
Hi stevejpage,
By using the sample data in your PBIX file, we are unable to get the above Matrix visual. We should drag a field into Values of Matrix, otherwise, we will get the error message “can't display the data because power bi can't determine the relationship between two or more fields”.
I use the fields in the following screenshot to create the Matrix visual, and filter the visual by setting Site Access Profile ID to 33.
Please note that in the above example, you don’t need to add any additional tables, just create relationships using Site Access Profile ID fields between GroupSiteAccessProfile table and other tables. For more details, please review this attached PBIX file.
Thanks,
Lydia Zhang