Forum Discussion
DAX Comparison Operations do not support comparing values of type true/false with values of type txt
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.⚡
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,
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