KNOWLEDGE BASE

IsMemberOf Function Returns Wrong Results When Filtering User Accounts


Published: 01 Aug 2016
Last Modified Date: 28 Jun 2018

Issue

When filtering user accounts from multiple domains using the IsMemberOf function, the filter might incorrectly return a value of 'false'.  

Environment

  • Tableau Desktop
  • Tableau Server

Resolution

Active Directory

The Active Directory domain must be declared in the calculation with the group name. For example: ISMEMBEROF(‘domain.lan\group’)

Specific domain

  1. Make sure the user is logged into Tableau Server. In contrast to the behavior of other user functions, ISMEMBEROF can only test for group membership when logged into Tableau Server. This behavior is due to the fact that ISMEMBEROF uses Tableau Server groups only.
  2. Make sure the group exists on Tableau Server, and that the user is a part of the group. Make sure the user and the group each have the correct domains.
  3. Instead of using the syntax ISMEMBEROF('group'), specify the domain:
    ISMEMBEROF('domain\group')
    Replace domain with the group's domain, and replace group with the name of the group.
     

Cause

The user account was imported into Tableau Server from a different Active Directory domain.

Additional Information

ISMEMBEROF pulls its information from Tableau Server. A user logs in to Tableau Server from a specific domain. Unless a different domain is specified, the ISMEMBEROF function checks the user's domain for the group name.
Did this article resolve the issue?