Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

DAX Measure error

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] = "Comp...
Need Help
  • mh2587's avatar
    mh2587
    2 years ago
    Escalated = //Try this one
IF (
    (VALUE(Complaints[Escalated Complaint]) = 1 || VALUE(Complaints[Escalated Complaint]) = 0)
        && Complaints[Category] = "Compliant",
    "Yes",
    "No"
)
mh2587's avatar
mh2587
Super User
2 years ago
Escalated = //Try this one
IF (
    (VALUE(Complaints[Escalated Complaint]) = 1 || VALUE(Complaints[Escalated Complaint]) = 0)
        && Complaints[Category] = "Compliant",
    "Yes",
    "No"
)
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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