Forum Discussion
DAX comparison operations do not support comparing values of type Integer with values of type T/F
- 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"
)
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"
)
Worked like a charm. Thank you.