Master Item for table

[Kirsten]

My master item does not display the desired result in the table. See attachment for description. 

[tm_burgers]

I would recommend using set analysis:

count({<[Never Connected]={'1'}>}  distinct EquipmentID)