Forum Discussion

JamesMF1982's avatar
JamesMF1982
Frequent Visitor
3 years ago
Solved

Using Search in a measure

HI all,   I'm hoping someone can help me. I have a column (RESIDENT[AdminType]) that has a load of varying data in there which represents a number of settings. For example "NurseLABench" that will ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi JamesMF1982 
    If you are creating a measure then you may try

    Key Word =
IF (
    HASONEVALUE ( RESIDENT[AdminType] ),
    CONCATENATEX (
        VALUES ( RESIDENT[AdminType] ),
        SWITCH (
            TRUE (),
            CONTAINSSTRING ( RESIDENT[AdminType], "Nurse" ), "Nursing",
            CONTAINSSTRING ( RESIDENT[AdminType], "LA" ), "Local Authority"
        )
    )
)
JamesMF1982's avatar
JamesMF1982
Frequent Visitor
3 years ago

Hi, I have tried this but when I use the CONTAINSSTRING option, the column I am trying to reference is not available for selection.

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi JamesMF1982 
If you are creating a measure then you may try

Key Word =
IF (
    HASONEVALUE ( RESIDENT[AdminType] ),
    CONCATENATEX (
        VALUES ( RESIDENT[AdminType] ),
        SWITCH (
            TRUE (),
            CONTAINSSTRING ( RESIDENT[AdminType], "Nurse" ), "Nursing",
            CONTAINSSTRING ( RESIDENT[AdminType], "LA" ), "Local Authority"
        )
    )
)