Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX Measure error on concentrate, within Concentrate

Hi Experts

 

Cannot see where the error in in the following when applying it to managed role.

the end result need to be (country)[Bu_Code]

VAR _User = CONTAINSSTRING(
    USERPRINCIPALNAME(),
CONCATENATE(   
CONCATENATE(
        "(",
        CONCATENATE(
            [country_dim.country_name],
            ")"),
                CONCATENATE(
                    "["
                     CONCATENATE(
            [bu_code],
            "]")
    )
)
)
RETURN

 

 

 

  • Anonymous's avatar
    Anonymous
    3 years ago
    VAR _User = CONTAINSSTRING(
        USERPRINCIPALNAME(),
       CONCATENATE(
            CONCATENATE(
            "(",
            CONCATENATE(
                [country_dim.country_name],
                ")")
        ),
        CONCATENATE(
            "[",
            CONCATENATE(
                [bu_code],
                "]")
        ))
    )
    RETURN 
    _User

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    VAR _User = CONTAINSSTRING(
        USERPRINCIPALNAME(),
       CONCATENATE(
            CONCATENATE(
            "(",
            CONCATENATE(
                [country_dim.country_name],
                ")")
        ),
        CONCATENATE(
            "[",
            CONCATENATE(
                [bu_code],
                "]")
        ))
    )
    RETURN 
    _User