Forum Discussion
Error DAX comparison operations do not support comparing values of type Text with values of type Int
- 7 years ago
Seems to me that DIFF column is formatted as text.
Try this
Measure = CALCULATE ( COUNTROWS ( FILTER ( 'Table1', VALUE ( 'Table1'[Diff] ) = 0 ) ) )
- 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
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
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.
- Anonymous7 years agoNot applicable
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.