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

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
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

  • BBIUser's avatar
    BBIUser
    Helper IV
    7 years ago

    I was trying to change the Measure's data type to Whole number instead of the Custom Column. Changing the Custom Column to Whole Number data type with my original DAX worked for me as suggested by Cherie.

     

    Thanks for the Solutions v-cherch-msft , Zubair_Muhammad and Anonymous.

    • 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.