Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

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

Now when I do the Messure I received this error. 

 

 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous 

Please try

Column = IF ( ISERROR ( VALUE ( 'Table1'[Issue Resolution] ) ), 0, 15 )

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Still receving this error

     

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Anonymous 
      You are placing another column in the visual! Please use

      Column = IF ( ISERROR ( VALUE ( 'Table1'[Earned Points] ) ), 0, 15 )

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Ok, based on your initial reccomendation a created a Calculated Column for Each Column that needs to be graded and that can be an NA. Then i Created a Messure That is the Base Points= 

        Base Points = SUMX(Table1, Table1[Issue Resolution Points] + Table1[Complete and Accurate Information Points] + Table1[Apology and Empathy Points] + Table1[Sentence Structure (spelling, punctuation, grammar) Points] + Table1[Adaptation to Consumer Style Points] + Table1[Tone, Respect and Friendliness Points] + Table1[Proper Branding Points] + Table1[Adherence to Escalation Process Points] + Table1[Response time within Threshold Points] + Table1[Adherence to other Business Policies/Processes Points] + Table1[Capture Consumer Information for Order/RA/Escalation Points] + Table1[Capture & Document the correct MN, SN & Purchase Date Points] + Table1[Correct Category and Disposition Points] + Table1[Documentation Points] + Table1[Soft Upsell Points])
         
        Then I Created the Earned Points Messure that is the SUM of the values of the Original columns that is this one: 
        Earned Points = SUMX(Table1, Table1[Issue Resolution] + Table1[Complete and Accurate Information] + Table1[Apology and Empathy] + Table1[Sentence Structure (spelling, punctuation, grammar)] + Table1[Adaptation to Consumer Style] + Table1[Tone, Respect and Friendliness] + Table1[Proper Branding] + Table1[Adherence to Escalation Process] + Table1[Response time within Threshold] + Table1[Adherence to other Business Policies/Processes] + Table1[Capture Consumer Information for Order/RA/Escalation] + Table1[Capture & Document the correct MN, SN & Purchase Date] + Table1[Correct Category and Disposition] + Table1[Documentation] + Table1[Soft Upsell]) How do I add an NA Rule for the Earn Points that are the ones that have the NA.