Forum Discussion

PripowerBI1234's avatar
PripowerBI1234
Frequent Visitor
4 years ago
Solved

Comparing string to text in SWITCH

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

 

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    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"
)

3 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    4 years ago

    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"
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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