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

BBIUser's avatar
BBIUser
Helper IV
7 years ago

Thanks Anonymous for the reply.

I did try this expression before posting here with slight modification in it and I was getting the same error . I dint place ('Table1'[Diff]) , the coulmn since I had used the Custom Column which is not showing while creating this expression and shows only the Table Name for COUNTROWS.

 

Measure = CALCULATE( COUNTROWS( 'Table1') , FILTER('Table1', 'Table1'[Diff]=0 ) )

 

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
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 ) ) )