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

MEGHS's avatar
MEGHS
Frequent Visitor
3 years ago

hello, as I'm running into this same error, I'd like to see if someone can help: my columns are all date/time-formatted columns, and I still get the error. I suspect it has to do with the fact that there are empty cells which show "null" in Power Query. Can it be that PBI does not function to calculate the difference between two dates in case there are empty cells?? and if so, how would you suggest to fix it? thanks a lot!