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
4 years ago

I am returning the same error message with my code and am not sure which columns are not in the correct format... 

 

I am trying to fill empty rows with entries later on.