Forum Discussion

Traceout's avatar
Traceout
Frequent Visitor
1 year ago
Solved

DAX comparison operations do not support comparing values of type Integer with values of type T/F

I'm getting the following error when creating a new column:   DAX comparison operations do not support comparing values of type Integer with values of type True/False. Consider using the VALUE or...
  • Gabry's avatar
    1 year ago

    Hello,

    I don't think it can work like that. Try this:

     

    DEVCAT SWITCH =
    SWITCH (
    TRUE(),
    CONTAINSSTRING('TEMP STATES - ALL'[DEVCAT], "84"), "SECTIONALIZER",

    AND(
    CONTAINSSTRING('TEMP STATES - ALL'[DEVCAT], "4"),
    CONTAINSSTRING('TEMP STATES - ALL'[DEVICE], "SC_")
    ), "SECTIONALIZER",

    AND(
    CONTAINSSTRING('TEMP STATES - ALL'[DEVCAT], "4"),
    CONTAINSSTRING('TEMP STATES - ALL'[DEVICE], "SW_")
    ), "SWITCH",

    AND(
    CONTAINSSTRING('TEMP STATES - ALL'[DEVCAT], "4"),
    CONTAINSSTRING('TEMP STATES - ALL'[DEVICE], "_CB")
    ), "FEEDER",

    CONTAINSSTRING('TEMP STATES - ALL'[DEVCAT], "4"), "SWITCH",
    CONTAINSSTRING('TEMP STATES - ALL'[DEVCAT], "18"), "FUSE",
    CONTAINSSTRING('TEMP STATES - ALL'[DEVCAT], "8"), "SERVICE TRANSFORMER",
    CONTAINSSTRING('TEMP STATES - ALL'[DEVCAT], "19"), "RECLOSER",
    CONTAINSSTRING('TEMP STATES - ALL'[DEVCAT], "21"), "RECLOSER",
    CONTAINSSTRING('TEMP STATES - ALL'[DEVCAT], "26"), "LINECUT",
    CONTAINSSTRING('TEMP STATES - ALL'[DEVCAT], "92"), "SERVICE",
    CONTAINSSTRING('TEMP STATES - ALL'[DEVCAT], "9"), "TRANSMISSION",

    ISBLANK('TEMP STATES - ALL'[DEVCAT]), "BLANK",

    "REPORT"
    )