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 )  
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.
      • tamerj1's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        4 years ago

        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..... } )