Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX Comparison Operations do not support comparing values of type true/false with values of type txt

Hi All,   I am trying to do a large measure to convert unit of measure in a production report. I keep getting the below error message on my dax formula. Can you help??   Error Message: MdxScript...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous sorry for the late reply, if you want to check AND , it has to be two && instead of single, single & means concatenate values and that's surely a problem, change it to this &&

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous logically it should work, since there are too many conditions, maybe one of it is failing, for debugging, try simple calculation for each condition to see if it all work and maybe you missed something and debug will help to find out the issue.

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks parry2k  - I was able to narrow down what is giving the error. 

 

It is when I try to write the statement below in bold. Do you think it has something to do with the & sign? I just want it to look at the quantity manufactured UM and if it is "E" and the Prod-Pkg Weight UM is "kg" then I want it to calculate the value (which is not the error portion. 

 

'BATCH-REC-HDR'[Qty-Manufactured-UM]="E" & 'BATCH-REC-HDR'[PROD-PKG.Weight-UM]="kg", 'BATCH-REC-HDR'[Quantity-Manufactured]*'BATCH-REC-HDR'[PROD-PKG.Weight]*2.2046,

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous sorry for the late reply, if you want to check AND , it has to be two && instead of single, single & means concatenate values and that's surely a problem, change it to this &&

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      parry2k  you are a lifesaver. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous 

    parry2khas pointed out the cause of the error. "&" is a sign that connects, or concatenates, two values to produce one continuous text value, whereas "&&" is the AND condition you need, change it to double ampersand "&&" should work. 

     

    Best Regards

    Paul Zheng _ Community Support Team