Comparing string to text in SWITCH

[PripowerBI1234]

Hi,

Has anyone come across an error as below and have any alterntaive suggestions?

ERROR: "DAX comparison operations do not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values."

I am trying to merge 4 different measures to create a single drop down slicer. While using the SWITCH I have conditions that compare text values of one column with numerical values of another column to arrive at the result but in SWITCH it is unable to compare the text with the numbers. 

example:

Choice = SWITCH(TRUE(),

COUNTROWS(FILTER(Table1,Table1[Column1]= "123" && Table1[Column2]= BLANK())),"Result1",

COUNTROWS(FILTER(Table1,Table1[Column1]= "123" && Table1[Column2]= "A")),"Result2",

COUNTROWS(FILTER(Table1,Table1[Column1]= "5" && Table1[Column3]= "C")),"Result3",

(Table1[Column4])-([Measure1]+[Measure2]),"Result4")

Thanks

[v-stephen-msft]

Hi @PripowerBI1234 ,

Could you please tell me that your problem has been solved? If it has, please mark the helpful reply as a solution and more people will benefit from it.

Best Regards,

Stephen Tao

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your dataset looks like, but could you please try the below whether it works?

Choice =
SWITCH (
    TRUE (),
    COUNTROWS (
        FILTER ( Table1, Table1[Column1] = 123 && Table1[Column2] = BLANK () )
    ), "Result1",
    COUNTROWS ( FILTER ( Table1, Table1[Column1] = 123 && Table1[Column2] = "A" ) ), "Result2",
    COUNTROWS ( FILTER ( Table1, Table1[Column1] = 5 && Table1[Column3] = "C" ) ), "Result3",
    ( Table1[Column4] ) - ( [Measure1] + [Measure2] ), "Result4"
)

[PripowerBI1234]

Thank you this helped me solve the problem.