Have you already referred to these two links:
Thank you for reaching out to me. Yes, I have seen the links below & unfortunately, there are not much help.
two things I noticed..
1. your If statement does not include a clause that will allow for member of AD_Group_2 & AD_Group_3 to see data for LocationB and LocationC. The method you picked to handle the filter with the IF/Then statement would require for every combination to be there.
2. There is another way to approach this which would require you to build a table which specifies the AD Group name and the Locations they should have access to. The link that Tracy included speaks to using that middle table to join in. That is a different way to approach this issue but from what I've seen of your issue that is the way I would go.
I hope this helps.
Well, you found the same 'bummer' that I ran into. The 'ismemberof' function only works against Tableau Server Groups, not active directory groups that have been imported into Tableau Server.