COUNT A FIELD BASED ON NULLS in another field

[abhi1693r]

Hello,
I had a similar issue. So I have two columns, PART AND CUBES, with one to many relationship.(one PART can have many CUBES or a PART can have no CUBE).
Scenario: If I select 3 PARTS which have 2 CUBES, wherein 2 PARTS have 2 CUBES and 1 PART has no CUBE. I want a count of all the CUBES plus any PART which has no CUBES.

PART	CUBES
SW1001	1415TV
DC1003	1323GT
BW1002

@ToniKautto 

So the count should be 2+1=3.
How can I implement this?

Regards,
Abhishek

[dwforest · Accepted solution]

Count(CUBES) + Count({<PART={"=IsNull(CUBES)"}>}PART)