Help with error: DAX comparison operations

data4good — Tue, 31 Dec 2024 19:05:09 GMT

Hello,

I've been searching this forum for help, but haven't managed to find a solution to my problem. I am trying to create a calculated column called HMG. HMG should equal 1 only if both of the following conditions are met: SAMPLE =1 AND State_Clean = "WA". Otherwise, the value for HMG should equal 0. I'm using the following syntax and getting the following error:

HMG = if(

Interaction_Table[SAMPLE]=1 & RELATED(Client_Table[State_Clean])="WA",1,0)

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 would love some help adjusting my syntax to work. SAMPLE is a calculated column so I'm not sure how to tell what type it is, but I'm guessing it's numeric since the values are 1 and 0. I assume State_Clean is a string.

Thank you!!

Re: Help with error: DAX comparison operations

lbendlin — Tue, 31 Dec 2024 19:31:50 GMT

the syntax for "and" is && , not & (which is a join operator)

Re: Help with error: DAX comparison operations

data4good — Tue, 31 Dec 2024 20:21:31 GMT

Ahhh that's it! Thank you so much!

topic Re: Help with error: DAX comparison operations in DAX Commands and Tips

Help with error: DAX comparison operations

Re: Help with error: DAX comparison operations

Re: Help with error: DAX comparison operations