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

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.