Hi Ken
Kindly seek your assistance please.
I have a lookup table that contains customer info and a data table that contains deposit account details (including foreign key). These tables are related via the customer id key.
How do I count the number of customers that do not have a deposit account? I understand that if the parent table (i.e. Customer lookup table) row has no corresponding row in the child table (i.e. deposit table), it throws up a blank.
So, after creating this base measure, [No. of customers]:=counta(Customertble[CustomerID]), how can I use this to count the blanks in the deposit data table (i.e. CustID that do not have any corresponding rows in the deposit data table)?
Alfred
Kindly seek your assistance please.
I have a lookup table that contains customer info and a data table that contains deposit account details (including foreign key). These tables are related via the customer id key.
How do I count the number of customers that do not have a deposit account? I understand that if the parent table (i.e. Customer lookup table) row has no corresponding row in the child table (i.e. deposit table), it throws up a blank.
So, after creating this base measure, [No. of customers]:=counta(Customertble[CustomerID]), how can I use this to count the blanks in the deposit data table (i.e. CustID that do not have any corresponding rows in the deposit data table)?
Alfred