CountAX errror with True/False vs Integer

[hoyty]

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.

[FreemanZ]

hi @hoyty ,

could you post some sample data of the absent column?

[hoyty]

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.

[FreemanZ · Accepted solution]

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:

https://smantindata.com/replace-null-values-in-power-query/#aioseo-replace-null-with-0