EnumValue

Returns the internal numeric value for a text value in a text list.

Syntax

EnumValue (enum_string)
ParameterDescription

enum_string

Either textlistname.string_literal or textlistmembername.string_literal, where

  • textlistname is the name of a text list defined on the outline

  • textlistmembername is the name of a member that has an associated text list

  • string_literal is the text value stored in the text list

Example

The following expression shows how EnumValue can be used to filter employees based on their title, which is stored as a text list in [Measures].[Title].

FILTER([Employee].Levels[0].Members, [Measures].[Title] = EnumValue([Job Titles]."Manager") )