cannot convert value text to type true/false

[prakritnepal-cn]

Hi, 

I am trying to use sumx to calculate a total column. I get following error of cannot convert value type: 

My formula used is (on the screenshot as well) : sumx( filter (table1, related (table2'[column with one to many join with table1)]) && bunch of criteria),Table1[balance]) 

table relationship screenshot: 

How can I modify the formula to go around this error?

Thank you for your help

[Chilarejo5]

Hi everyone,

I am trying to define define an "Implemented state" in a column; where I have to identified if it is "Imported into Production" or "Completed" this must be identified as Implemented:

If(OR(modified[Status] = "Imported into Production" , "Completed"),"Implemented","No Implemented")

Warning message is showing: Cannot convert value 'Completed' of type text to Type True/False

What can I do for fix it?

Thanks!

[Greg_Deckler · Accepted solution]

@prakritnepal-cn - I have to believe that the error is coming from your RELATED function. I would try removing that to see if it is in fact the issue.