Function 'SWITCH' does not support comparing values of type True/False with values of type Text. Con

[MBWATSON]

Hello! I am fairly new to Power BI and I have seen questions similar to mine but the answers aren't working to solve my issue. I have the following SWITCH statement

ROLE = SWITCH (

        TRUE (),

            '_VIB Report 2022 08 07'[STATUS CHANGED BY] = "DYER, HEIDI S" && '_VIB Report 2022 08 07'[DEPARTMENT] = "WILSONVILLE", "PCP", "VIB" ,

            '_VIB Report 2022 08 07'[STATUS CHANGED BY] = "MINGS, JENNIFER" && '_VIB Report 2022 08 07'[DEPARTMENT] = "TANASBOURNE", "PCP", "VIB",

            '_VIB Report 2022 08 07'[STATUS CHANGED BY] = "HOJNACKI, LAUREN A" && '_VIB Report 2022 08 07'[DEPARTMENT] = "GLISAN", "PCP", "VIB")  

It is returning this error messge

Function 'SWITCH' does not support comparing values of type True/False with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.

The previous posts have shown text statements. Any help appreciated!

[MBWATSON · Accepted solution]

Unfortunately it is still throwing the same error.

[tamerj1]

Hi @MBWATSON 
Please try

ROLE =
SWITCH (
    VAR ChangedBy = '_VIB Report 2022 08 07'[STATUS CHANGED BY]
    VAR Department = '_VIB Report 2022 08 07'[DEPARTMENT]
    RETURN
        TRUE (),
    ChangedBy = "DYER, HEIDI S"
        && Department = "WILSONVILLE", "PCP",
    ChangedBy = "MINGS, JENNIFER"
        && Department = "TANASBOURNE", "PCP",
    ChangedBy = "HOJNACKI, LAUREN A"
        && Department = "GLISAN", "PCP",
    "VIB"
)

[MBWATSON]

Now I am getting this error message

Failed to resolve name 'ChangedBy'. It is not a valid table, variable, or function name.

[tamerj1]

@MBWATSON 
Strange that this is a key word. However, try

ROLE =
SWITCH (
    VAR _ChangedBy = '_VIB Report 2022 08 07'[STATUS CHANGED BY]
    VAR _Department = '_VIB Report 2022 08 07'[DEPARTMENT]
    RETURN
        TRUE (),
    _ChangedBy = "DYER, HEIDI S"
        && _Department = "WILSONVILLE", "PCP",
    _ChangedBy = "MINGS, JENNIFER"
        && _Department = "TANASBOURNE", "PCP",
    _ChangedBy = "HOJNACKI, LAUREN A"
        && _Department = "GLISAN", "PCP",
    "VIB"

[MBWATSON · Accepted solution]

Unfortunately it is still throwing the same error.

[tamerj1 · Accepted solution]

@MBWATSON 
Ok must be my mistake. Please try

ROLE =
VAR ChangedBy = '_VIB Report 2022 08 07'[STATUS CHANGED BY]
VAR Department = '_VIB Report 2022 08 07'[DEPARTMENT]
RETURN
    SWITCH (
        TRUE (),
        ChangedBy = "DYER, HEIDI S"
            && Department = "WILSONVILLE", "PCP",
        ChangedBy = "MINGS, JENNIFER"
            && Department = "TANASBOURNE", "PCP",
        ChangedBy = "HOJNACKI, LAUREN A"
            && Department = "GLISAN", "PCP",
        "VIB"
    )