DAX Measure error

[Anonymous]

Hi Experts

Getting an error on the following measure - cannot work it out.

Escalated = IF(VALUE(Complaints[Escalated Complaint] = 1 || [Escalated Complaint] = 0) && Complaints[Category] = "Compliant","Yes","No")

Error message

DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.

[mh2587 · Accepted solution]

Escalated = //Try this one
IF (
    (VALUE(Complaints[Escalated Complaint]) = 1 || VALUE(Complaints[Escalated Complaint]) = 0)
        && Complaints[Category] = "Compliant",
    "Yes",
    "No"
)

[Anonymous]

Arrrr my column with escalted compliants is a text field not numbers 1 or 0 and i cannot change to whole number

[Anonymous]

Hi mh still getting the following error Cannot convert value '' of type Text to type Number.