Forum Discussion
CountAX errror with True/False vs Integer
I am trying to make a measure like this
AbsentCount = COUNTAX(FILTER('Attendance Review','Attendance Review'[Absent] = TRUE() && ISBLANK('Attendance Review'[SignoutTime])),'Attendance Review'[Absent])When I try to pull that measure into a table I get this message
Couldn't load the data for this visual
MdxScript(Model) (37, 76) Calculation error in measure 'Attendance Review'[AbsentCount]: DAX comparison operations do not support comparing values of type True/False with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.
This is pulling data from an Azure SQL view. The Absent column is of type boolean. I tried = 1 as well and got same error. I tried removing the && and second expression and got same error as well. Not sure what I am doing wrong.
hi hoyty ，
the issue is now clear:
null and 1 are of different data type. Try to change all null to 1 in PQ, then your measure shall work.How:
3 Replies
Hi,
It is boolean that is generally either NULL or 1. Ocassionally it is a 0 due to someone being marked absent and then cleared. This is from SQL SMS.
hi hoyty ，
the issue is now clear:
null and 1 are of different data type. Try to change all null to 1 in PQ, then your measure shall work.How:
