Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Calculation error in measure 'Tbl[Measu]: Cannot convert value "HI" of type text to type True/False

Hi,

 

I am recibing this error in a table I am crating where I have a column named "Measu" in "Table1" and it has values of type text. And I created and measure to see if is not any of this value then "Error" is not "Ok". Any idea how can I fix it?

Measu

Value 1

Value 2

Value 3

Value 4

Value 5

 

Check =
Var Hello = SELECTEDVALUE(TBL[Measu])
Return
IF(Hello <> "Value 1" || "Value 2" || "Value 3" || "Value 4" || "Value 5", "Error", "Ok")
 

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

1 Reply

  • Manoj_Nair's avatar
    Manoj_Nair
    Icon for Solution Supplier rankSolution Supplier
    3 years ago

    Anonymous- Try this and let me know if this works or not. If this fix your problem, mark my post as a solution and give it a thumbs up. 😀

    Check =
VAR Hello = SELECTEDVALUE('Table1'[Measu])
RETURN
IF(NOT(Hello IN {"Value 1", "Value 2", "Value 3", "Value 4", "Value 5"}), "Error", "Ok")