Forum Discussion
Solved
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'[Absen...
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:
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: