Issue
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
Last Modified Date: 01 Feb 2023
Argument 1 to ISMEMBEROF must be a(n) string literal
Environment
- Tableau Desktop
- Tableau Server
Resolution
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...
Cause
The ISMEMBEROF() function only accepts string literals. A string literal is a single text value. A string field contains many string literals.Additional Information
To voice your support for the inclusion of this enhancement in a future product release, add your vote to the following Community Idea: https://community.tableau.com/s/idea/0874T000000HAShQAO/detail
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials