try once, remove ATTR and see
Getting the same error if I remove ATTR... I've also tried making "Assessment" ATTR but that doesn't work either.
IF CONTAINS([Assessment],"CCC" ) THEN "123"
ELSEIF CONTAINS([sheet1].[Location],"AA99" ) THEN "ABC"
can you put screenshot of the same?
The second code I'm using is
If Contains(ATTR[Assessment]."CCC") Then "123"
Elseif Contains(ATTR([sheet1].[Location]),"AA99") Then "ABC"
This is a valid calculation, but when I use it in view it ignores the "Contains" from the second data source and does not return CIM. It calculates Assessment on the first data source correctly.