Count giving inaccurate result

[PaReD_SF85]

I have a table in my new application that has only 1 of 6 columns not giving accurate counts, yet all columns are calculated the in the same manner.

Expression that should be resulting in 0 (zero):   Count({<[Other]={'X'}>}[Type])

Others as above but substitute [Other] with [Soap], [Lotion], etc.   (They are accurate totals based on the data)

Reference Table used and output results:

Type	Summed Type	Soap	Lotion	Towels	Rug	Bedding	Other
Condo	Owned	X			X	X
Rental	Non-Owned	X	X	X		X
Room Only	Non-Owned	X	X	X	X	X
House	Owned	X	X			X
Type	Summed Type	Soap	Lotion	Towels	Rug	Bedding	Other
Condo	Owned	9			9	9	9
Rental	Non-Owned	43	43	43		43	43
Room Only	Non-Owned	17	17	17	17	17	17
House	Owned	38	38			38	38
Total		107	98	60	26	107	107
Should be		107	98	60	26	107	0

Is 'Other' a reserved word by chance?  I moved Other to not be right most column (thinking it was using it as a total column), but the results are the same.

Thank you in advance for your assistance!

[PaReD_SF85]

I just added a line in the load to assign 'blank' when the field length is 0...and now it works.  Not sure the difference to make it count as if nulls were the character 'X' though?