Forum Discussion
Relationship Problems
Here are the tables with the Security Group link made
Hi stevejpage, thanks for the image.
What you would need to do, is to centralize all of the "Site Profile Access ID" into one table.
Fortunately I did make a note of a very interesting blog post from Jeffery Wang, where he goes into some detail on how to achieve this.
You can find the blog post here: Connect any number of tables together via a common column
That's a great and very easy-to-use tutorial right there!
I tried that, and got most of the way there, and the DAX of
All Groups = FILTER( DISTINCT( UNION( DISTINCT(GroupSiteAccessProfile [Record Identifier]), distinct(GroupSiteAccessProfileWithcriti[Record Identifier]), DISTINCT(GroupSiteAccessProfileWithreque[List of Included Requested Sites: Record Identifier]), DISTINCT(GroupSiteAccessProfileWithvalid[Record Identifier]))),not(isblank([Record Identifier])))
resulted in another table that had the unitque record identifiers (which are the profile assignment numbers in the system, and with the relationships in the below photo, I sitll haven't been able to get the last step of the way, which is to be able to create a matrix that will show:
1. Site Access Profile ID
2. Security Group
3. Site Access Profile Name
4. Valid Sites
5. Critical Sites
6. Requested Sites
Once I add the final step (Requested), it barfs out on me.
Also, as you can see in the photo, it lists the Critical Sites over and over and over. I can't figure that one out so that it only shows once.
Hi stevejpage I would suggest changing the Relationship direction from Both to Single, that should then eliminate the duplicates coming through?