Hi Guys Im having this issue when trying to create a calculate column. I Type in the following condition: Column = IF ( 'Table1'[Issue Resolution] = "NA", 0, 15 )

Anonymous You need to apply this to all columns. Use power query for that. Select all the numerical columns and replace NA wil null or 0. Other thing I noticed, it would be much easier if you first unpivot all the numerical columns then replace the null. Then In DAX you can do something like Base Points = CALCULATE ( SUM ( Table1[Value] ), Table1[Attribute] IN { "Issue Resolution Points", "Complete and Accurate Information Points", etc..... } )

Hi,Check if your datatype in [issue resolution] column is something besides "Text": I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Hi Anonymous what is the data type of the column Issue Resolution. Can you share a screenshot of that column?

Hi tamerj1 The Column data type is number but one of the values can be NA.Here it is

ValtteriN Hi Yes, The Column can have 3 values 15, 0 or NA.

DAX comparison do not support comparing values of type integer with values of type text

13 Replies

ValtteriN
Community Champion
4 years ago
Hi,

Check if your datatype in [issue resolution] column is something besides "Text":

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
tamerj1
Community Champion
4 years ago
Hi Anonymous

what is the data type of the column Issue Resolution. Can you share a screenshot of that column?
- Anonymous
  Not applicable
  4 years ago
  Hi tamerj1 The Column data type is number but one of the values can be NA.
  Here it is
  - tamerj1
    Community Champion
    4 years ago
    Anonymous
    
    Please try
    
    Column = IF ( ISBLANK ( 'Table1'[Issue Resolution] ), 0, 15 )
Anonymous
Not applicable
4 years ago
ValtteriN Hi Yes, The Column can have 3 values 15, 0 or NA.

Forum Discussion

DAX comparison do not support comparing values of type integer with values of type text

13 Replies

Related content

Comparison Chart

BI Tools Comparison

Campaign Voucher FAQ & Support

DAX comparison operations do not support comparing values of type Text with values of type Integer

DAX comparison operations do not support comparing values of type Number with values of type Text.