Pivot Tables Counts Blank Cells when calculating Distinct Values

[FahadSid]

Hello All,

I am trying to create a pivot table which should show the distinct values for Data elements in Column 1, these Data Elements are connected with Objects 1,2,3 with the names given in the table below.

Data E	Object 1	Object 2	Object 3
Account ID	ACC_ID	DQ_R1	DQ_C1
Account Code		DQ_R1
Instrument	INS_ID	DQ_R1	DQ_C1
Element X		DQ_R1	DQ_C1
Element X	ELE_Y	DQ_R2
No element	NO_ELE	DQ_R2	DQ_C2
Yes Element	ACC_ID	DQ_R1	DQ_C1
Yes Element	ACC_ID2	DQ_R2	DQ_C2

I was able to create a pivot table which shows distinct values - but the problem is it count Blank cells as '1'. which is incorrect. Please see the pivot table below.
See How ElementX shows its connect with Object 1 twice but in actuality its connected only once.

 

[FahadSid]

Can this be resolved by creating a Calculated field? Calculated fields only works with Sum function.

I used this formula '=counta(unique('Data E' )) but it returns 1 as the answer for all the fields. Please let me know if you can help.