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] = "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.
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"
)

3 Replies

  • 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

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

    • 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