Forum Discussion

BBIUser's avatar
BBIUser
Helper IV
7 years ago
Solved

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

Hi,   How do I show the result set in a 'Multi-row card of only 0 values from the Custom Column?  Sample data is provided below:   - Difference is a Custom Column which I created in the Po...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    BBIUser

     

    Seems to me that DIFF column is formatted as text.

     

    Try this

     

    Measure =
CALCULATE ( COUNTROWS ( FILTER ( 'Table1', VALUE ( 'Table1'[Diff] ) = 0 ) ) )
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi BBIUser

     

    You may try to change the type of Diff column to 'Whole Number'. Then your measure will not get the error.

     

    Regards,

    Cherie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Does anyone know how to find the DAX error when you have formatted every single data table and combined data table to ensure there will be no format errors and there are no warning symbols on any files?  I hit the error when trying to add a new measure to a visual.  I am basically reproducing the same report I have already done but I need to change the number of reports so I started over and now I can't get any of the equations to work without the DAX format error.  Thanks

kbuckvol's avatar
kbuckvol
Advocate I
7 years ago

Did you figure this out?  I am running into the same issue. All my look up values are text but I'm getting and error message about mixed types.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I had a sum on one of my measures that after I changed it not to summarize I did not get this error anymore.  That probably doesn't help.  I also had the same sum in a prior version and I didn't get this error so I am not sure what exactly fixed it.  I did have a mix of numbers and text, I checked every single table again to see if I could find one that had multiple formats and there were none.