Unable to Use a String Field in the ISMEMBEROF() function

Published: 25 Jul 2016
Last Modified Date: 01 Feb 2023


When attempting to use a text, aka string, field inside of the function ISMEMBEROF(), then Tableau Desktop returns the error:

Argument 1 to ISMEMBEROF must be a(n) string literal



  • Tableau Desktop
  • Tableau Server


Depending on the how ISMEMBEROF() is being used, a possible workaround is to create a parameter from the string field and then use the parameter inside of ISMEMBEROF(). A parameter can be created from a dimension by right-clicking on the dimension in the data pane and selecting Create > Parameter...


The ISMEMBEROF() function only accepts string literals. A string literal is a single text value. A string field contains many string literals.
Did this article resolve the issue?