2 of 2 people found this helpful
Have you tried something like this on Tableau Desktop
ELSEIF ISMEMBEROF('Group2') then [Oranges]
Thanks Amit, this certainly is helpful!
glad, it was helpful
I used the above solution, but i would like to go abit further and use more filters per user group.
Assume that there are 3 filter strings:
Apples Oranges and Grapes
Using the same Example, How do I:
then [Apples] AND [Oranges]
ELSEIF ISMEMBEROF('Group2') then [ALL]
1) "AND [Oranges]" I would like to specify group 1 to have both Apples and Oranges ticked
2) [ALL] I would like to specify group 2 to have all the values ticked - i.e. Apples, Oranges, and Grapes
What is the correct syntax for doing so?
Thanks in advance....
I am little bit confused about your requirement. When earlier you said regarding [Apples] & [Oranges]. I was under impression those were two completely different fields and not values of same field something like [Fruit].
i.e Do want Managers to have access to [Sales] and Sales People have access to [Targets]
or Managers to have access to all sales people and each sales people should have access only to subset of data.
Let me know if I have understood it correctly. If you are looking for the 2nd version. You can try this.
Going off of Amit's Answer as well here is a possible solution if I understand your question correctly.
IF ISMEMBEROF('Group1') AND ([Fruit] = [Oranges] OR [Fruit] = [Apples])
I hope this is helpful,
Amit Narkar - To make is clearer, let's use the below:
I have two user groups - Group 1 and Group 2
Members in "Group 1" - Should only be able to view all the graphs relating to a Dimension in Fruit called "Orange"
Members in "Group 2" - Should only be able to view all the graphs relating to a Dimension in Fruit called "Apples"
Currently I have the below calculated field [IsMember_Calc_Field]:
if ISMEMBEROF("Group 1") then "Orange"
ELSEIF ISMEMBEROF("Group 2") then "Apples"
The above does not give any error, but this is doing nothing to filter the Dimension Fruit to "Orange" or to "Apples" based on the Group 1 / Group 2 user group. I need some sort of filter mechanism in the calc field that is driven by the user group.
Hi Nathan Flanagan, hopefully the above is clear. But to also clarify, I tried using the below additional calc field.
There are no errors, but this is also not enforcing the filters based on User Group.
if ISMEMBEROF("Group 1") AND ([Fruit] = "Orange") then "Orange"
ELSEIF ISMEMBEROF("Group 2") AND ([Fruit] = "Apples") then "Apples"