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"
)
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"
)
  • PripowerBI1234's avatar
    PripowerBI1234
    Frequent Visitor
    4 years ago

    Thank you this helped me solve the problem.