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